PES_MACRO_EXPAND_MULTIPLE_OBJECT_ID returns a comma-separated list of object IDs for a given list of items or resource team IDs; the returned list can also include child objects, if specified. The format '2;45;69:true' returns a comma separated list of IDs, including children IDs.
SELECT obj_UID FROM PES_Object WHERE obj_UID
IN PES_FUNCTION_INVESTMENT_IDS_FORMATTER(2;3;4:true)