APPS.GHR_CPDF_STATRPT dependencies on PER_PERIODS_OF_SERVICE

Line 125: PER_PERIODS_OF_SERVICE PPS ,

121: SELECT
122: DECODE(PER.CURRENT_EMPLOYEE_FLAG, 'Y', PPS.DATE_START, DECODE(PER.CURRENT_NPW_FLAG, 'Y', PPP.DATE_START, NULL)) hire_date
123: FROM
124: PER_PEOPLE_F PER ,
125: PER_PERIODS_OF_SERVICE PPS ,
126: PER_PERIODS_OF_PLACEMENT PPP
127: WHERE
128: PPS.PERSON_ID (+) = PER.PERSON_ID AND
129: PPP.PERSON_ID (+) = PER.PERSON_ID AND

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

132: P_REPORT_DATE BETWEEN PER.EFFECTIVE_START_DATE AND PER.EFFECTIVE_END_DATE AND
133: (
134: (PER.EMPLOYEE_NUMBER IS NULL) OR
135: (PER.EMPLOYEE_NUMBER IS NOT NULL AND
136: PPS.DATE_START = (SELECT MAX(PPS1.DATE_START) FROM PER_PERIODS_OF_SERVICE PPS1 WHERE PPS1.PERSON_ID = PER.PERSON_ID AND
137: PPS1.DATE_START <= PER.EFFECTIVE_END_DATE))) AND
138: ((PER.NPW_NUMBER IS NULL) OR (PER.NPW_NUMBER IS NOT NULL AND
139: PPP.DATE_START = (SELECT MAX(PPP1.DATE_START) FROM PER_PERIODS_OF_PLACEMENT PPP1 WHERE PPP1.PERSON_ID = PER.PERSON_ID AND
140: PPP1.DATE_START <= PER.EFFECTIVE_END_DATE)));