APPS.PER_PERUSHIR_XMLP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 210: PER_PERIODS_OF_SERVICE PPS

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
214: ,C_END_OF_TIME)

Line 247: PER_PERIODS_OF_SERVICE PPS

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
251: AND PPS.ACTUAL_TERMINATION_DATE IS NOT NULL

Line 257: PER_PERIODS_OF_SERVICE PPS2

253: AND not exists (
254: SELECT
255: 1
256: FROM
257: PER_PERIODS_OF_SERVICE PPS2
258: WHERE PPF.PERSON_ID = PPS2.PERSON_ID
259: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS2.DATE_START
260: AND NVL(PPS2.ACTUAL_TERMINATION_DATE
261: ,C_END_OF_TIME) )

Line 413: PER_PERIODS_OF_SERVICE PPS

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
417: ,C_END_OF_TIME)

Line 456: PER_PERIODS_OF_SERVICE PPS

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
460: AND PPS.ACTUAL_TERMINATION_DATE IS NOT NULL

Line 466: PER_PERIODS_OF_SERVICE PPS2

462: AND not exists (
463: SELECT
464: 1
465: FROM
466: PER_PERIODS_OF_SERVICE PPS2
467: WHERE PPF.PERSON_ID = PPS2.PERSON_ID
468: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS2.DATE_START
469: AND NVL(PPS2.ACTUAL_TERMINATION_DATE
470: ,C_END_OF_TIME) )

Line 497: V_DATE_START PER_PERIODS_OF_SERVICE.DATE_START%TYPE;

493: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;
494: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;
495: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;
496: V_DOB PER_ALL_PEOPLE_F.DATE_OF_BIRTH%TYPE;
497: V_DATE_START PER_PERIODS_OF_SERVICE.DATE_START%TYPE;
498: V_HEADER NUMBER;
499: V_BUFFER VARCHAR2(120);
500: V_BOOLEAN BOOLEAN;
501: BEGIN