APPS.AP_WORKFLOW_PKG dependencies on PER_EMPLOYEES_CURRENT_X

Line 5185: FROM per_employees_current_x

5181: -- see if we have an TCA/WF Directory api for this select
5182: /*
5183: SELECT supervisor_id
5184: INTO l_esc_approver_id
5185: FROM per_employees_current_x
5186: WHERE employee_id = l_approver_id;
5187: */
5188: -- bug#6837841 Changes Starts
5189: /*SELECT user_id

Line 5194: FROM per_employees_current_x

5190: INTO l_esc_approver_id
5191: FROM fnd_user
5192: WHERE employee_id =
5193: (SELECT supervisor_id
5194: FROM per_employees_current_x
5195: WHERE employee_id = l_approver_id);
5196:
5197: WF_DIRECTORY.GetUserName('FND_USR',
5198: l_esc_approver_id,

Line 5207: FROM per_employees_current_x

5203: l_esc_role,
5204: l_esc_role_display);*/
5205:
5206: SELECT supervisor_id INTO l_esc_approver_id
5207: FROM per_employees_current_x
5208: WHERE employee_id = l_approver_id;
5209:
5210: WF_DIRECTORY.GetUserName('PER',
5211: l_esc_approver_id,

Line 5401: FROM per_employees_current_x

5397: --amy see if we have an TCA/WF Directory api for this select
5398: /*
5399: SELECT supervisor_id
5400: INTO l_esc_approver_id
5401: FROM per_employees_current_x
5402: WHERE employee_id = l_approver_id;
5403: */
5404: /* -- commented for 8682244
5405: SELECT user_id

Line 5410: FROM per_employees_current_x

5406: INTO l_esc_approver_id
5407: FROM fnd_user
5408: WHERE employee_id =
5409: (SELECT supervisor_id
5410: FROM per_employees_current_x
5411: WHERE employee_id = l_approver_id);
5412:
5413:
5414: WF_DIRECTORY.GetUserName('FND_USR',

Line 5425: FROM per_employees_current_x

5421: l_esc_role,
5422: l_esc_role_display);
5423: */
5424: SELECT supervisor_id INTO l_esc_approver_id
5425: FROM per_employees_current_x
5426: WHERE employee_id = l_approver_id;
5427:
5428: WF_DIRECTORY.GetUserName('PER',
5429: l_esc_approver_id,