DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on FND_USER

Line 5023: FROM fnd_user

5019: */
5020: -- bug#6837841 Changes Starts
5021: /*SELECT user_id
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);

Line 5202: FROM fnd_user

5198: WHERE employee_id = l_approver_id;
5199: */
5200: SELECT user_id
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);

Line 7553: FROM FND_USER

7549: l_invoice_total NUMBER;
7550:
7551: CURSOR c_get_user ( p_rec_role IN VARCHAR2 ) IS
7552: SELECT user_id,employee_id
7553: FROM FND_USER
7554: WHERE USER_NAME=p_rec_role;
7555:
7556: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7557: Select response

Line 7915: FROM FND_USER

7911:
7912:
7913: CURSOR c_get_user ( p_rec_role IN VARCHAR2 ) IS
7914: SELECT user_id,employee_id
7915: FROM FND_USER
7916: WHERE USER_NAME=p_rec_role;
7917:
7918: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7919: Select response