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;
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;
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;
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;
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;
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;
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:
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;
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:
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;
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 ,