DBA Data[Home] [Help]

APPS.PER_PERUSHIR_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 208: HR_LOCATIONS_ALL HL,

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

Line 245: HR_LOCATIONS_ALL HL,

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

Line 411: HR_LOCATIONS_ALL HL,

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

Line 454: HR_LOCATIONS_ALL HL,

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