205: PER_ALL_PEOPLE_F PPF,
206: PER_ALL_ASSIGNMENTS_F PAF,
207: HR_SOFT_CODING_KEYFLEX HSCF,
208: HR_LOCATIONS_ALL HL,
209: PER_JOBS JOB,
210: PER_PERIODS_OF_SERVICE PPS
211: WHERE PPS.PERSON_ID = PPF.PERSON_ID
212: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
213: AND NVL(PPS.ACTUAL_TERMINATION_DATE
242: PER_ALL_PEOPLE_F PPF,
243: PER_ALL_ASSIGNMENTS_F PAF,
244: HR_SOFT_CODING_KEYFLEX HSCF,
245: HR_LOCATIONS_ALL HL,
246: PER_JOBS JOB,
247: PER_PERIODS_OF_SERVICE PPS
248: WHERE PPS.PERSON_ID = PPF.PERSON_ID
249: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
250: AND PPF.EFFECTIVE_END_DATE
408: PER_ALL_PEOPLE_F PPF,
409: PER_ALL_ASSIGNMENTS_F PAF,
410: HR_SOFT_CODING_KEYFLEX HSCF,
411: HR_LOCATIONS_ALL HL,
412: PER_JOBS JOB,
413: PER_PERIODS_OF_SERVICE PPS
414: WHERE PPS.PERSON_ID = PPF.PERSON_ID
415: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
416: AND NVL(PPS.ACTUAL_TERMINATION_DATE
451: PER_ALL_PEOPLE_F PPF,
452: PER_ALL_ASSIGNMENTS_F PAF,
453: HR_SOFT_CODING_KEYFLEX HSCF,
454: HR_LOCATIONS_ALL HL,
455: PER_JOBS JOB,
456: PER_PERIODS_OF_SERVICE PPS
457: WHERE PPS.PERSON_ID = PPF.PERSON_ID
458: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
459: AND PPF.EFFECTIVE_END_DATE