APPS.HXC_APPROVAL_WF_PKG dependencies on WF_LOCAL_ROLES

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 998: l_approver_id wf_local_roles.orig_system_id%type;

994: select employee_id
995: from fnd_user
996: where user_id = userId;
997:
998: l_approver_id wf_local_roles.orig_system_id%type;
999: l_approver_system wf_local_roles.orig_system%type;
1000:
1001:
1002: Begin

Line 999: l_approver_system wf_local_roles.orig_system%type;

995: from fnd_user
996: where user_id = userId;
997:
998: l_approver_id wf_local_roles.orig_system_id%type;
999: l_approver_system wf_local_roles.orig_system%type;
1000:
1001:
1002: Begin
1003: