DBA Data[Home] [Help]

APPS.AP_WEB_DB_SCHLINE_PKG dependencies on PER_CONT_WORKERS_CURRENT_X

Line 114: FROM PER_CONT_WORKERS_CURRENT_X PCW

110: WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)= 'Y'
111: AND EMP.EMPLOYEE_ID = p_employee_id
112: UNION
113: SELECT PCW.ASSIGNMENT_ID , PCW.PERSON_ID
114: FROM PER_CONT_WORKERS_CURRENT_X PCW
115: WHERE PCW.PERSON_ID = p_employee_id) EMPLOYEE,
116: PER_ALL_ASSIGNMENTS_F PF
117: WHERE
118: PF.ASSIGNMENT_ID = EMPLOYEE.ASSIGNMENT_ID