APPS.AP_WEB_DB_SCHLINE_PKG dependencies on PER_EMPLOYEES_X

Line 53: FROM per_employees_x P

49: AND SL.STATUS = 'ACTIVE'
50: AND SL.SCHEDULE_PERIOD_ID = SP.SCHEDULE_PERIOD_ID
51: AND SP.POLICY_ID = SH.POLICY_ID
52: AND PF.ASSIGNMENT_ID IN ( SELECT P.ASSIGNMENT_ID
53: FROM per_employees_x P
54: WHERE P.EMPLOYEE_ID = p_employee_id
55: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(P.employee_id)='Y'
56: UNION ALL
57: SELECT P.ASSIGNMENT_ID