DBA Data[Home] [Help]

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 1288: FROM PER_EMPLOYEES_X EMP

1284: SELECT WF.ORGANIZATION_ID
1285: FROM
1286: (SELECT EMP.ORGANIZATION_ID ORGANIZATION_ID,
1287: EMP.EMPLOYEE_ID PERSON_ID
1288: FROM PER_EMPLOYEES_X EMP
1289: WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)='Y'
1290: AND EMP.EMPLOYEE_ID = p_person_id
1291: UNION ALL
1292: SELECT CWK.ORGANIZATION_ID ORGANIZATION_ID,