APPS.AP_WEB_DB_HR_INT_PKG dependencies on WF_USERS

Line 794: l_employee_name wf_users.name%type;

790:
791: FUNCTION GetEmployeeName(
792: p_employee_id IN NUMBER
793: ) RETURN VARCHAR2 IS
794: l_employee_name wf_users.name%type;
795: l_employee_display_name wf_users.display_name%type;
796:
797: BEGIN
798:

Line 795: l_employee_display_name wf_users.display_name%type;

791: FUNCTION GetEmployeeName(
792: p_employee_id IN NUMBER
793: ) RETURN VARCHAR2 IS
794: l_employee_name wf_users.name%type;
795: l_employee_display_name wf_users.display_name%type;
796:
797: BEGIN
798:
799: WF_DIRECTORY.GetUserName('PER',

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;