5: select distinct substr(wa.function,1,instr(wa.function,'.')-1) package_name,
6: substr(wa.function,instr(wa.function,'.')+1) procedure_name,
7: wa.item_type,
8: wa.name 9: from wf_activities wa 10: where wa.type='FUNCTION'
11: and wa.function like 'PO%'
12: and wa.item_type like x_item_type;
13: