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 359: FROM fnd_user

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

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

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

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

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

Line 950: FROM fnd_user

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