eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PERUSHIR_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 234: PER_ALL_PEOPLE_F PPF,

230: PPF.PERSON_ID,
231: PPF.LAST_NAME,
232: PPF.FIRST_NAME
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,

Line 272: PER_ALL_PEOPLE_F PPF,

268: PPF.PERSON_ID,
269: PPF.LAST_NAME,
270: PPF.FIRST_NAME
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,

Line 439: PER_ALL_PEOPLE_F PPF,

435: PPF.NATIONAL_IDENTIFIER,
436: PPF.DATE_OF_BIRTH,
437: PPS.DATE_START
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,

Line 482: PER_ALL_PEOPLE_F PPF,

478: PPF.NATIONAL_IDENTIFIER,
479: PPF.DATE_OF_BIRTH,
480: PPS.DATE_START
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,

Line 522: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;

518: AND PPF.PER_INFORMATION7 is NULL
519: ORDER BY
520: 2,
521: 3;
522: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
523: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE;
524: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;
525: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;
526: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;

Line 523: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE;

519: ORDER BY
520: 2,
521: 3;
522: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
523: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE;
524: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;
525: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;
526: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;
527: V_DOB PER_ALL_PEOPLE_F.DATE_OF_BIRTH%TYPE;

Line 524: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;

520: 2,
521: 3;
522: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
523: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE;
524: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;
525: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;
526: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;
527: V_DOB PER_ALL_PEOPLE_F.DATE_OF_BIRTH%TYPE;
528: V_DATE_START PER_PERIODS_OF_SERVICE.DATE_START%TYPE;

Line 525: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;

521: 3;
522: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
523: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE;
524: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;
525: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;
526: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;
527: V_DOB PER_ALL_PEOPLE_F.DATE_OF_BIRTH%TYPE;
528: V_DATE_START PER_PERIODS_OF_SERVICE.DATE_START%TYPE;
529: V_HEADER NUMBER;

Line 526: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;

522: V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
523: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE;
524: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;
525: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;
526: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;
527: V_DOB PER_ALL_PEOPLE_F.DATE_OF_BIRTH%TYPE;
528: V_DATE_START PER_PERIODS_OF_SERVICE.DATE_START%TYPE;
529: V_HEADER NUMBER;
530: V_BUFFER VARCHAR2(120);

Line 527: V_DOB PER_ALL_PEOPLE_F.DATE_OF_BIRTH%TYPE;

523: V_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE;
524: V_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;
525: V_MIDDLE_NAME PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE;
526: V_SSN PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE;
527: V_DOB PER_ALL_PEOPLE_F.DATE_OF_BIRTH%TYPE;
528: V_DATE_START PER_PERIODS_OF_SERVICE.DATE_START%TYPE;
529: V_HEADER NUMBER;
530: V_BUFFER VARCHAR2(120);
531: V_BOOLEAN BOOLEAN;