DBA Data[Home] [Help]

APPS.PER_PERUSHIR_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 205: PER_ALL_PEOPLE_F PPF,

201: PPF.PERSON_ID,
202: PPF.LAST_NAME,
203: PPF.FIRST_NAME
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,

Line 242: PER_ALL_PEOPLE_F PPF,

238: PPF.PERSON_ID,
239: PPF.LAST_NAME,
240: PPF.FIRST_NAME
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,

Line 408: PER_ALL_PEOPLE_F PPF,

404: PPF.NATIONAL_IDENTIFIER,
405: PPF.DATE_OF_BIRTH,
406: PPS.DATE_START
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,

Line 451: PER_ALL_PEOPLE_F PPF,

447: PPF.NATIONAL_IDENTIFIER,
448: PPF.DATE_OF_BIRTH,
449: PPS.DATE_START
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,

Line 491: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;

487: AND PPF.PER_INFORMATION7 is NULL
488: ORDER BY
489: 2,
490: 3;
491: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
492: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%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;

Line 492: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE;

488: ORDER BY
489: 2,
490: 3;
491: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
492: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%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;

Line 493: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;

489: 2,
490: 3;
491: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
492: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%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;

Line 494: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;

490: 3;
491: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
492: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%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;

Line 495: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;

491: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
492: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%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);

Line 496: V_DOB PER_ALL_PEOPLE_F.DATE_OF_BIRTH%TYPE;

492: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%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;