DBA Data[Home] [Help]

APPS.PER_PERUSHIR_XMLP_PKG dependencies on PER_JOBS

Line 209: PER_JOBS JOB,

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

Line 246: PER_JOBS JOB,

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

Line 412: PER_JOBS JOB,

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

Line 455: PER_JOBS JOB,

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