DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on WF_ROLES

Line 10361: FROM wf_roles

10357:
10358:
10359: CURSOR c_person_id IS
10360: SELECT orig_system_id
10361: FROM wf_roles
10362: WHERE orig_system = 'PER'
10363: AND name = l_TransferToName;
10364:
10365: BEGIN

Line 10932: l_approver_person_id wf_roles.orig_system_id%TYPE;

10928: l_notificationID NUMBER;
10929: l_Transferee wf_users.name%type;
10930: l_TransferToName wf_users.name%type;
10931:
10932: l_approver_person_id wf_roles.orig_system_id%TYPE;
10933:
10934: BEGIN
10935:
10936: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start UpdateApproverIdInHeaders');

Line 10967: FROM wf_roles

10963: l_debug_info := 'Get the transferee id';
10964: -----------------------------------------
10965:
10966: SELECT orig_system_id INTO l_approver_person_id
10967: FROM wf_roles
10968: WHERE orig_system = 'PER'
10969: AND name = l_TransferToName;
10970:
10971: