APPS.GHR_EEOC_STATUS_REPORT dependencies on PER_PERIODS_OF_PLACEMENT

Line 425: PER_PERIODS_OF_PLACEMENT PPP

421: CURSOR cur_per IS
422: SELECT DECODE(PER.CURRENT_EMPLOYEE_FLAG, 'Y', PPS.DATE_START, DECODE(PER.CURRENT_NPW_FLAG, 'Y', PPP.DATE_START, NULL)) hire_date
423: FROM per_all_people PER ,
424: PER_PERIODS_OF_SERVICE PPS ,
425: PER_PERIODS_OF_PLACEMENT PPP
426: WHERE PPS.PERSON_ID (+) = PER.PERSON_ID AND
427: PPP.PERSON_ID (+) = PER.PERSON_ID AND
428: PER.PERSON_ID = p_person_id AND
429: P_REPORT_DATE BETWEEN PER.EFFECTIVE_START_DATE AND PER.EFFECTIVE_END_DATE AND

Line 435: PPP.DATE_START = (SELECT MAX(PPP1.DATE_START) FROM PER_PERIODS_OF_PLACEMENT PPP1 WHERE PPP1.PERSON_ID = PER.PERSON_ID AND

431: (PER.EMPLOYEE_NUMBER IS NOT NULL AND
432: PPS.DATE_START = (SELECT MAX(PPS1.DATE_START) FROM PER_PERIODS_OF_SERVICE PPS1 WHERE PPS1.PERSON_ID = PER.PERSON_ID AND
433: PPS1.DATE_START <= PER.EFFECTIVE_END_DATE))) AND
434: ((PER.NPW_NUMBER IS NULL) OR (PER.NPW_NUMBER IS NOT NULL AND
435: PPP.DATE_START = (SELECT MAX(PPP1.DATE_START) FROM PER_PERIODS_OF_PLACEMENT PPP1 WHERE PPP1.PERSON_ID = PER.PERSON_ID AND
436: PPP1.DATE_START <= PER.EFFECTIVE_END_DATE)));
437:
438: --
439: BEGIN