DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on WF_NOTIFICATIONS

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

827: cursor c_find_approver_role
828: (itemType in wf_items.item_type%type
829: ,itemKey in wf_item_activity_statuses.item_key%type) is
830: select wlr.orig_system, wlr.orig_system_id
831: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr
832: where pa.activity_name = 'TC_APR_NOTIFICATION'
833: and pa.activity_item_type = itemType
834: and pa.instance_id = wias.process_activity
835: and wias.notification_id = wn.notification_id