DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on PER_CONT_WORKERS_CURRENT_X

Line 88: 'FROM PER_CONT_WORKERS_CURRENT_X CWK ' ||

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 || ' ' ||
88: 'FROM PER_CONT_WORKERS_CURRENT_X CWK ' ||
89: 'WHERE CWK.PERSON_ID = :b2) wf';
90:
91: OPEN cur FOR l_query_stmt USING p_employee_id, p_employee_id;
92:

Line 1333: FROM PER_CONT_WORKERS_CURRENT_X CWK

1329: AND EMP.EMPLOYEE_ID = p_person_id
1330: UNION ALL
1331: SELECT CWK.ORGANIZATION_ID ORGANIZATION_ID,
1332: CWK.PERSON_ID
1333: FROM PER_CONT_WORKERS_CURRENT_X CWK
1334: WHERE CWK.PERSON_ID = p_person_id) WF;
1335:
1336: person_rec person_cur%ROWTYPE;
1337: