APPS.AP_WEB_DB_SCHLINE_PKG dependencies on PER_EMPLOYEES_X
Line 109: FROM PER_EMPLOYEES_X EMP
105: (decode(SH.ROLE_CODE,'JOB_GROUP', PF.job_id,'POSITION',PF.position_id,'GRADE',PF.grade_id,0)),0) INTO l_role_code
106: FROM
107: AP_POL_HEADERS SH,
108: (SELECT EMP.ASSIGNMENT_ID ,EMP.EMPLOYEE_ID 109: FROM PER_EMPLOYEES_X EMP 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