APPS.GHR_CPDF_EHRIS dependencies on PER_PERIODS_OF_SERVICE

Line 243: PER_PERIODS_OF_SERVICE PPS ,

239: SELECT
240: DECODE(PER.CURRENT_EMPLOYEE_FLAG, 'Y', PPS.DATE_START, DECODE(PER.CURRENT_NPW_FLAG, 'Y', PPP.DATE_START, NULL)) hire_date
241: FROM
242: per_all_people PER ,
243: PER_PERIODS_OF_SERVICE PPS ,
244: PER_PERIODS_OF_PLACEMENT PPP
245: WHERE
246: PPS.PERSON_ID (+) = PER.PERSON_ID AND
247: PPP.PERSON_ID (+) = PER.PERSON_ID AND

Line 252: PPS.DATE_START = (SELECT MAX(PPS1.DATE_START) FROM PER_PERIODS_OF_SERVICE PPS1 WHERE PPS1.PERSON_ID = PER.PERSON_ID AND

248: PER.PERSON_ID = p_person_id AND
249: (
250: (PER.EMPLOYEE_NUMBER IS NULL) OR
251: (PER.EMPLOYEE_NUMBER IS NOT NULL AND
252: PPS.DATE_START = (SELECT MAX(PPS1.DATE_START) FROM PER_PERIODS_OF_SERVICE PPS1 WHERE PPS1.PERSON_ID = PER.PERSON_ID AND
253: PPS1.DATE_START <= PER.EFFECTIVE_END_DATE))) AND
254: ((PER.NPW_NUMBER IS NULL) OR (PER.NPW_NUMBER IS NOT NULL AND
255: PPP.DATE_START = (SELECT MAX(PPP1.DATE_START) FROM PER_PERIODS_OF_PLACEMENT PPP1 WHERE PPP1.PERSON_ID = PER.PERSON_ID AND
256: PPP1.DATE_START <= PER.EFFECTIVE_END_DATE)));