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_ADDRESSES

Line 451: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;

447: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
448:
449:
450:
451: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
452: L_DATE_FROM DATE;
453: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
454: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

Line 453: L_COUNTRY PER_ADDRESSES.COUNTRY%type;

449:
450:
451: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
452: L_DATE_FROM DATE;
453: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
454: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

Line 454: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

450:
451: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
452: L_DATE_FROM DATE;
453: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
454: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

Line 455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

451: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
452: L_DATE_FROM DATE;
453: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
454: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
459: L_REGION_1 PER_ADDRESSES.REGION_1%type;

Line 456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

452: L_DATE_FROM DATE;
453: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
454: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
459: L_REGION_1 PER_ADDRESSES.REGION_1%type;
460: L_REGION_2 PER_ADDRESSES.REGION_1%type;

Line 457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

453: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
454: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
459: L_REGION_1 PER_ADDRESSES.REGION_1%type;
460: L_REGION_2 PER_ADDRESSES.REGION_1%type;
461: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

Line 458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

454: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
459: L_REGION_1 PER_ADDRESSES.REGION_1%type;
460: L_REGION_2 PER_ADDRESSES.REGION_1%type;
461: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
462:

Line 459: L_REGION_1 PER_ADDRESSES.REGION_1%type;

455: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
459: L_REGION_1 PER_ADDRESSES.REGION_1%type;
460: L_REGION_2 PER_ADDRESSES.REGION_1%type;
461: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
462:
463: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;

Line 460: L_REGION_2 PER_ADDRESSES.REGION_1%type;

456: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
459: L_REGION_1 PER_ADDRESSES.REGION_1%type;
460: L_REGION_2 PER_ADDRESSES.REGION_1%type;
461: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
462:
463: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
464:

Line 461: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

457: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
458: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
459: L_REGION_1 PER_ADDRESSES.REGION_1%type;
460: L_REGION_2 PER_ADDRESSES.REGION_1%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;

Line 510: PER_ADDRESSES padr ,

506: HL2.MEANING NATIONALITY,
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 ,