APPS.AP_WORKFLOW_PKG dependencies on PER_EMPLOYEES_CURRENT_X

Line 5017: FROM per_employees_current_x

5013: -- see if we have an TCA/WF Directory api for this select
5014: /*
5015: SELECT supervisor_id
5016: INTO l_esc_approver_id
5017: FROM per_employees_current_x
5018: WHERE employee_id = l_approver_id;
5019: */
5020: -- bug#6837841 Changes Starts
5021: /*SELECT user_id

Line 5026: FROM per_employees_current_x

5022: INTO l_esc_approver_id
5023: FROM fnd_user
5024: WHERE employee_id =
5025: (SELECT supervisor_id
5026: FROM per_employees_current_x
5027: WHERE employee_id = l_approver_id);
5028:
5029: WF_DIRECTORY.GetUserName('FND_USR',
5030: l_esc_approver_id,

Line 5039: FROM per_employees_current_x

5035: l_esc_role,
5036: l_esc_role_display);*/
5037:
5038: SELECT supervisor_id INTO l_esc_approver_id
5039: FROM per_employees_current_x
5040: WHERE employee_id = l_approver_id;
5041:
5042: WF_DIRECTORY.GetUserName('PER',
5043: l_esc_approver_id,

Line 5197: FROM per_employees_current_x

5193: --amy see if we have an TCA/WF Directory api for this select
5194: /*
5195: SELECT supervisor_id
5196: INTO l_esc_approver_id
5197: FROM per_employees_current_x
5198: WHERE employee_id = l_approver_id;
5199: */
5200: SELECT user_id
5201: INTO l_esc_approver_id

Line 5205: FROM per_employees_current_x

5201: INTO l_esc_approver_id
5202: FROM fnd_user
5203: WHERE employee_id =
5204: (SELECT supervisor_id
5205: FROM per_employees_current_x
5206: WHERE employee_id = l_approver_id);
5207:
5208:
5209: WF_DIRECTORY.GetUserName('FND_USR',