APPS.AP_WEB_AUDIT_UTILS dependencies on PER_EMPLOYEES_X

Line 83: 'FROM PER_EMPLOYEES_X EMP ' ||

79:
80: l_query_stmt := 'select ' || p_column || ' ' ||
81: 'from ' ||
82: '(SELECT ' || l_column1 || ' ' || p_column || ' ' ||
83: 'FROM PER_EMPLOYEES_X EMP ' ||
84: 'WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)=''Y'' ' ||
85: 'AND EMP.EMPLOYEE_ID = :b1 ' ||
86: 'UNION ALL ' ||
87: 'SELECT ' || l_column2 || ' ' || p_column || ' ' ||

Line 1327: FROM PER_EMPLOYEES_X EMP

1323: SELECT WF.ORGANIZATION_ID
1324: FROM
1325: (SELECT EMP.ORGANIZATION_ID ORGANIZATION_ID,
1326: EMP.EMPLOYEE_ID PERSON_ID
1327: FROM PER_EMPLOYEES_X EMP
1328: WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)='Y'
1329: AND EMP.EMPLOYEE_ID = p_person_id
1330: UNION ALL
1331: SELECT CWK.ORGANIZATION_ID ORGANIZATION_ID,