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_DELTA_SYNC_MESSAGES dependencies on PER_ADDRESSES

Line 896: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;

892: L_TITLE VARCHAR2(30);
893: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
894: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
895: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
896: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
897: L_DATE_FROM DATE;
898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

Line 898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;

894: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
895: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
896: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
897: L_DATE_FROM DATE;
898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

Line 899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

895: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
896: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
897: L_DATE_FROM DATE;
898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

Line 900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

896: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
897: L_DATE_FROM DATE;
898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
904: L_REGION_1 PER_ADDRESSES.REGION_1%type;

Line 901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

897: L_DATE_FROM DATE;
898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
904: L_REGION_1 PER_ADDRESSES.REGION_1%type;
905: L_REGION_2 PER_ADDRESSES.REGION_1%type;

Line 902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
904: L_REGION_1 PER_ADDRESSES.REGION_1%type;
905: L_REGION_2 PER_ADDRESSES.REGION_1%type;
906: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

Line 903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
904: L_REGION_1 PER_ADDRESSES.REGION_1%type;
905: L_REGION_2 PER_ADDRESSES.REGION_1%type;
906: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
907: L_EMAIL_ADDRESS per_all_people_f.email_address%type;

Line 904: L_REGION_1 PER_ADDRESSES.REGION_1%type;

900: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
904: L_REGION_1 PER_ADDRESSES.REGION_1%type;
905: L_REGION_2 PER_ADDRESSES.REGION_1%type;
906: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
907: L_EMAIL_ADDRESS per_all_people_f.email_address%type;
908: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;

Line 905: L_REGION_2 PER_ADDRESSES.REGION_1%type;

901: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
904: L_REGION_1 PER_ADDRESSES.REGION_1%type;
905: L_REGION_2 PER_ADDRESSES.REGION_1%type;
906: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
907: L_EMAIL_ADDRESS per_all_people_f.email_address%type;
908: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
909: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;

Line 906: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

902: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
904: L_REGION_1 PER_ADDRESSES.REGION_1%type;
905: L_REGION_2 PER_ADDRESSES.REGION_1%type;
906: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
907: L_EMAIL_ADDRESS per_all_people_f.email_address%type;
908: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
909: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
910: L_NATIONALITY VARCHAR2(30);

Line 960: PER_ADDRESSES padr ,

956: ppf.business_group_id,
957: ppf.LAST_UPDATE_DATE
958:
959: FROM PER_ALL_PEOPLE_F ppf,
960: PER_ADDRESSES padr ,
961: PER_PHONES ppn ,
962: hr_lookups HL1 ,
963: HR_LOOKUPS HL2 ,
964: HR_LOOKUPS HL3 ,

Line 1074: PER_ADDRESSES padr ,

1070: ppf.business_group_id,
1071: ppf.LAST_UPDATE_DATE
1072:
1073: FROM PER_ALL_PEOPLE_F ppf,
1074: PER_ADDRESSES padr ,
1075: PER_PHONES ppn ,
1076: hr_lookups HL1 ,
1077: HR_LOOKUPS HL2 ,
1078: HR_LOOKUPS HL3 ,