DBA Data[Home] [Help]

APPS.PER_PERUSHIR_XMLP_PKG dependencies on PER_JOBS

Line 238: PER_JOBS JOB,

234: PER_ALL_PEOPLE_F PPF,
235: PER_ALL_ASSIGNMENTS_F PAF,
236: HR_SOFT_CODING_KEYFLEX HSCF,
237: HR_LOCATIONS_ALL HL,
238: PER_JOBS JOB,
239: PER_PERIODS_OF_SERVICE PPS
240: WHERE PPS.PERSON_ID = PPF.PERSON_ID
241: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
242: AND NVL(PPS.ACTUAL_TERMINATION_DATE

Line 276: PER_JOBS JOB,

272: PER_ALL_PEOPLE_F PPF,
273: PER_ALL_ASSIGNMENTS_F PAF,
274: HR_SOFT_CODING_KEYFLEX HSCF,
275: HR_LOCATIONS_ALL HL,
276: PER_JOBS JOB,
277: PER_PERIODS_OF_SERVICE PPS
278: WHERE PPS.PERSON_ID = PPF.PERSON_ID
279: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
280: AND PPF.EFFECTIVE_END_DATE

Line 443: PER_JOBS JOB,

439: PER_ALL_PEOPLE_F PPF,
440: PER_ALL_ASSIGNMENTS_F PAF,
441: HR_SOFT_CODING_KEYFLEX HSCF,
442: HR_LOCATIONS_ALL HL,
443: PER_JOBS JOB,
444: PER_PERIODS_OF_SERVICE PPS
445: WHERE PPS.PERSON_ID = PPF.PERSON_ID
446: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
447: AND NVL(PPS.ACTUAL_TERMINATION_DATE

Line 486: PER_JOBS JOB,

482: PER_ALL_PEOPLE_F PPF,
483: PER_ALL_ASSIGNMENTS_F PAF,
484: HR_SOFT_CODING_KEYFLEX HSCF,
485: HR_LOCATIONS_ALL HL,
486: PER_JOBS JOB,
487: PER_PERIODS_OF_SERVICE PPS
488: WHERE PPS.PERSON_ID = PPF.PERSON_ID
489: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
490: AND PPF.EFFECTIVE_END_DATE