APPS.AMW_WF_HIERARCHY_PKG dependencies on WF_PROCESS_ACTIVITIES

Line 970: from wf_process_activities wpa,

966: select process_id into child_id from amw_process where name = c1_rec.child_nondisp_name;
967:
968: select wpa.instance_id
969: into instance_id
970: from wf_process_activities wpa,
971: wf_activities wa
972: where wpa.process_item_type = 'AUDITMGR'
973: and wpa.process_name = p_process_name
974: and wpa.process_name = wa.name