APPS.HXC_APPROVAL_WF_PKG dependencies on WF_PROCESS_ACTIVITIES

Line 983: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr

979: cursor c_find_approver_role
980: (itemType in wf_items.item_type%type
981: ,itemKey in wf_item_activity_statuses.item_key%type) is
982: select wlr.orig_system, wlr.orig_system_id
983: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr
984: where pa.activity_name in('TC_APR_NOTIFICATION', 'TC_APR_NOTIFICATION_ABS')
985: and pa.activity_item_type = itemType
986: and pa.instance_id = wias.process_activity
987: and wias.notification_id = wn.notification_id

Line 4736: l_process_name wf_process_activities.process_name%type;

4732: --
4733: -- l_item_key wf_items.item_key%type;
4734: -- l_process_name varchar2(30);
4735: --
4736: l_process_name wf_process_activities.process_name%type;
4737: --
4738: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.start_approval_wf_process';
4739: --
4740: BEGIN