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

Line 873: p_address_type per_addresses.address_type%type,

869:
870: TYPE ADDRESS IS RECORD
871: (
872:
873: p_address_type per_addresses.address_type%type,
874: p_address_style per_addresses.style%type,
875: p_adr_date_from varchar2(10),
876: p_adr_date_to varchar2(10),
877: p_country per_addresses.country%type,

Line 874: p_address_style per_addresses.style%type,

870: TYPE ADDRESS IS RECORD
871: (
872:
873: p_address_type per_addresses.address_type%type,
874: p_address_style per_addresses.style%type,
875: p_adr_date_from varchar2(10),
876: p_adr_date_to varchar2(10),
877: p_country per_addresses.country%type,
878: p_addr_line1 per_addresses.address_line1%type,

Line 877: p_country per_addresses.country%type,

873: p_address_type per_addresses.address_type%type,
874: p_address_style per_addresses.style%type,
875: p_adr_date_from varchar2(10),
876: p_adr_date_to varchar2(10),
877: p_country per_addresses.country%type,
878: p_addr_line1 per_addresses.address_line1%type,
879: p_addr_line2 per_addresses.address_line2%type,
880: p_addr_line3 per_addresses.address_line3%type,
881: p_twn_or_city per_addresses.town_or_city%type,

Line 878: p_addr_line1 per_addresses.address_line1%type,

874: p_address_style per_addresses.style%type,
875: p_adr_date_from varchar2(10),
876: p_adr_date_to varchar2(10),
877: p_country per_addresses.country%type,
878: p_addr_line1 per_addresses.address_line1%type,
879: p_addr_line2 per_addresses.address_line2%type,
880: p_addr_line3 per_addresses.address_line3%type,
881: p_twn_or_city per_addresses.town_or_city%type,
882: p_tel_number1 per_addresses.telephone_number_1%type,

Line 879: p_addr_line2 per_addresses.address_line2%type,

875: p_adr_date_from varchar2(10),
876: p_adr_date_to varchar2(10),
877: p_country per_addresses.country%type,
878: p_addr_line1 per_addresses.address_line1%type,
879: p_addr_line2 per_addresses.address_line2%type,
880: p_addr_line3 per_addresses.address_line3%type,
881: p_twn_or_city per_addresses.town_or_city%type,
882: p_tel_number1 per_addresses.telephone_number_1%type,
883: p_region1 per_addresses.region_1%type,

Line 880: p_addr_line3 per_addresses.address_line3%type,

876: p_adr_date_to varchar2(10),
877: p_country per_addresses.country%type,
878: p_addr_line1 per_addresses.address_line1%type,
879: p_addr_line2 per_addresses.address_line2%type,
880: p_addr_line3 per_addresses.address_line3%type,
881: p_twn_or_city per_addresses.town_or_city%type,
882: p_tel_number1 per_addresses.telephone_number_1%type,
883: p_region1 per_addresses.region_1%type,
884: p_region2 per_addresses.region_2%type,

Line 881: p_twn_or_city per_addresses.town_or_city%type,

877: p_country per_addresses.country%type,
878: p_addr_line1 per_addresses.address_line1%type,
879: p_addr_line2 per_addresses.address_line2%type,
880: p_addr_line3 per_addresses.address_line3%type,
881: p_twn_or_city per_addresses.town_or_city%type,
882: p_tel_number1 per_addresses.telephone_number_1%type,
883: p_region1 per_addresses.region_1%type,
884: p_region2 per_addresses.region_2%type,
885: p_postal_code per_addresses.postal_code%type,

Line 882: p_tel_number1 per_addresses.telephone_number_1%type,

878: p_addr_line1 per_addresses.address_line1%type,
879: p_addr_line2 per_addresses.address_line2%type,
880: p_addr_line3 per_addresses.address_line3%type,
881: p_twn_or_city per_addresses.town_or_city%type,
882: p_tel_number1 per_addresses.telephone_number_1%type,
883: p_region1 per_addresses.region_1%type,
884: p_region2 per_addresses.region_2%type,
885: p_postal_code per_addresses.postal_code%type,
886: p_primary_flag per_addresses.primary_flag%type);

Line 883: p_region1 per_addresses.region_1%type,

879: p_addr_line2 per_addresses.address_line2%type,
880: p_addr_line3 per_addresses.address_line3%type,
881: p_twn_or_city per_addresses.town_or_city%type,
882: p_tel_number1 per_addresses.telephone_number_1%type,
883: p_region1 per_addresses.region_1%type,
884: p_region2 per_addresses.region_2%type,
885: p_postal_code per_addresses.postal_code%type,
886: p_primary_flag per_addresses.primary_flag%type);
887:

Line 884: p_region2 per_addresses.region_2%type,

880: p_addr_line3 per_addresses.address_line3%type,
881: p_twn_or_city per_addresses.town_or_city%type,
882: p_tel_number1 per_addresses.telephone_number_1%type,
883: p_region1 per_addresses.region_1%type,
884: p_region2 per_addresses.region_2%type,
885: p_postal_code per_addresses.postal_code%type,
886: p_primary_flag per_addresses.primary_flag%type);
887:
888: TYPE address_record is table of ADDRESS index by binary_integer;

Line 885: p_postal_code per_addresses.postal_code%type,

881: p_twn_or_city per_addresses.town_or_city%type,
882: p_tel_number1 per_addresses.telephone_number_1%type,
883: p_region1 per_addresses.region_1%type,
884: p_region2 per_addresses.region_2%type,
885: p_postal_code per_addresses.postal_code%type,
886: p_primary_flag per_addresses.primary_flag%type);
887:
888: TYPE address_record is table of ADDRESS index by binary_integer;
889:

Line 886: p_primary_flag per_addresses.primary_flag%type);

882: p_tel_number1 per_addresses.telephone_number_1%type,
883: p_region1 per_addresses.region_1%type,
884: p_region2 per_addresses.region_2%type,
885: p_postal_code per_addresses.postal_code%type,
886: p_primary_flag per_addresses.primary_flag%type);
887:
888: TYPE address_record is table of ADDRESS index by binary_integer;
889:
890: TYPE PHONE IS RECORD

Line 958: FROM per_addresses

954: Region_1,
955: Region_2,
956: Postal_Code,
957: Primary_Flag
958: FROM per_addresses
959: where person_id = p_person_id
960: and date_from between P_Eff_St_Dt and P_Eff_End_Dt
961: order by date_from;
962: