DBA Data[Home] [Help]

APPS.HR_FULL_SYNC_MESSAGES dependencies on PER_ADDRESSES

Line 452: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;

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

Line 454: L_COUNTRY PER_ADDRESSES.COUNTRY%type;

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

Line 455: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

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

Line 456: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

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

Line 457: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

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

Line 458: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

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

Line 459: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

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

Line 460: L_REGION_1 PER_ADDRESSES.REGION_1%type;

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

Line 461: L_REGION_2 PER_ADDRESSES.REGION_1%type;

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

Line 462: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

458: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
459: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
460: L_REGION_1 PER_ADDRESSES.REGION_1%type;
461: L_REGION_2 PER_ADDRESSES.REGION_1%type;
462: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
463:
464: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
465:
466: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;

Line 511: PER_ADDRESSES padr ,

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