APPS.AP_WEB_DB_HR_INT_PKG dependencies on FND_USER

Line 13: FROM fnd_user

9: --------------------------------------------------------------------------------
10: BEGIN
11: OPEN p_user_id_ref_cursor FOR
12: SELECT user_id
13: FROM fnd_user
14: WHERE employee_id = p_emp_id
15: ORDER BY creation_date;
16:
17: RETURN TRUE;

Line 358: FROM fnd_user

354: --------------------------------------------------------------------------------
355: BEGIN
356: SELECT employee_id
357: INTO p_emp_id
358: FROM fnd_user
359: WHERE user_id = p_user_id;
360:
361: return TRUE;
362:

Line 855: (SELECT 1 FROM fnd_user fnd, wf_users wf

851:
852: SELECT 1 into v_numRows
853: FROM DUAL
854: WHERE EXISTS
855: (SELECT 1 FROM fnd_user fnd, wf_users wf
856: WHERE fnd.user_name = wf.name and employee_id = p_emp_id
857: AND ORIG_SYSTEM not in ('HZ_PARTY','CUST_CONT')
858: AND status = 'ACTIVE')
859: and rownum=1;

Line 856: WHERE fnd.user_name = wf.name and employee_id = p_emp_id

852: SELECT 1 into v_numRows
853: FROM DUAL
854: WHERE EXISTS
855: (SELECT 1 FROM fnd_user fnd, wf_users wf
856: WHERE fnd.user_name = wf.name and employee_id = p_emp_id
857: AND ORIG_SYSTEM not in ('HZ_PARTY','CUST_CONT')
858: AND status = 'ACTIVE')
859: and rownum=1;
860:

Line 949: FROM fnd_user

945: ------------------------------------------------------------------
946: BEGIN
947:
948: SELECT user_id INTO p_user_id
949: FROM fnd_user
950: WHERE user_name = p_user_name;
951:
952: EXCEPTION
953: WHEN NO_DATA_FOUND THEN