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.HR_FULL_SYNC_MESSAGES dependencies on PER_PHONES

Line 465: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;

461: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
462:
463: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
464:
465: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
466: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
467:
468: L_NATIONALITY VARCHAR2(30);
469: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;

Line 466: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;

462:
463: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
464:
465: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
466: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
467:
468: L_NATIONALITY VARCHAR2(30);
469: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
470:

Line 511: PER_PHONES ppn ,

507: NATIONAL_IDENTIFIER
508:
509: FROM PER_ALL_PEOPLE_F ppf,
510: PER_ADDRESSES padr ,
511: PER_PHONES ppn ,
512: hr_lookups HL1 ,
513: HR_LOOKUPS HL2 ,
514: HR_LOOKUPS HL3 ,
515: HR_LOOKUPS HL4