APPS.AP_WEB_DB_HR_INT_PKG dependencies on WF_USERS

Line 793: l_employee_name wf_users.name%type;

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

Line 794: l_employee_display_name wf_users.display_name%type;

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

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;