DBA Data[Home] [Help]

APPS.PER_PERUSHIR_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 237: HR_LOCATIONS_ALL HL,

233: FROM
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

Line 275: HR_LOCATIONS_ALL HL,

271: FROM
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

Line 442: HR_LOCATIONS_ALL HL,

438: FROM
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

Line 485: HR_LOCATIONS_ALL HL,

481: FROM
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