DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on WF_NOTIFICATIONS

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