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 553: p_address_type per_addresses.address_type%type,

549:
550: TYPE ADDRESS IS RECORD
551: (
552:
553: p_address_type per_addresses.address_type%type,
554: p_address_style per_addresses.style%type,
555: p_adr_date_from varchar2(10),
556: p_adr_date_to varchar2(10),
557: p_country per_addresses.country%type,

Line 554: p_address_style per_addresses.style%type,

550: TYPE ADDRESS IS RECORD
551: (
552:
553: p_address_type per_addresses.address_type%type,
554: p_address_style per_addresses.style%type,
555: p_adr_date_from varchar2(10),
556: p_adr_date_to varchar2(10),
557: p_country per_addresses.country%type,
558: p_addr_line1 per_addresses.address_line1%type,

Line 557: p_country per_addresses.country%type,

553: p_address_type per_addresses.address_type%type,
554: p_address_style per_addresses.style%type,
555: p_adr_date_from varchar2(10),
556: p_adr_date_to varchar2(10),
557: p_country per_addresses.country%type,
558: p_addr_line1 per_addresses.address_line1%type,
559: p_addr_line2 per_addresses.address_line2%type,
560: p_addr_line3 per_addresses.address_line3%type,
561: p_twn_or_city per_addresses.town_or_city%type,

Line 558: p_addr_line1 per_addresses.address_line1%type,

554: p_address_style per_addresses.style%type,
555: p_adr_date_from varchar2(10),
556: p_adr_date_to varchar2(10),
557: p_country per_addresses.country%type,
558: p_addr_line1 per_addresses.address_line1%type,
559: p_addr_line2 per_addresses.address_line2%type,
560: p_addr_line3 per_addresses.address_line3%type,
561: p_twn_or_city per_addresses.town_or_city%type,
562: p_tel_number1 per_addresses.telephone_number_1%type,

Line 559: p_addr_line2 per_addresses.address_line2%type,

555: p_adr_date_from varchar2(10),
556: p_adr_date_to varchar2(10),
557: p_country per_addresses.country%type,
558: p_addr_line1 per_addresses.address_line1%type,
559: p_addr_line2 per_addresses.address_line2%type,
560: p_addr_line3 per_addresses.address_line3%type,
561: p_twn_or_city per_addresses.town_or_city%type,
562: p_tel_number1 per_addresses.telephone_number_1%type,
563: p_region1 per_addresses.region_1%type,

Line 560: p_addr_line3 per_addresses.address_line3%type,

556: p_adr_date_to varchar2(10),
557: p_country per_addresses.country%type,
558: p_addr_line1 per_addresses.address_line1%type,
559: p_addr_line2 per_addresses.address_line2%type,
560: p_addr_line3 per_addresses.address_line3%type,
561: p_twn_or_city per_addresses.town_or_city%type,
562: p_tel_number1 per_addresses.telephone_number_1%type,
563: p_region1 per_addresses.region_1%type,
564: p_region2 per_addresses.region_2%type,

Line 561: p_twn_or_city per_addresses.town_or_city%type,

557: p_country per_addresses.country%type,
558: p_addr_line1 per_addresses.address_line1%type,
559: p_addr_line2 per_addresses.address_line2%type,
560: p_addr_line3 per_addresses.address_line3%type,
561: p_twn_or_city per_addresses.town_or_city%type,
562: p_tel_number1 per_addresses.telephone_number_1%type,
563: p_region1 per_addresses.region_1%type,
564: p_region2 per_addresses.region_2%type,
565: p_postal_code per_addresses.postal_code%type);

Line 562: p_tel_number1 per_addresses.telephone_number_1%type,

558: p_addr_line1 per_addresses.address_line1%type,
559: p_addr_line2 per_addresses.address_line2%type,
560: p_addr_line3 per_addresses.address_line3%type,
561: p_twn_or_city per_addresses.town_or_city%type,
562: p_tel_number1 per_addresses.telephone_number_1%type,
563: p_region1 per_addresses.region_1%type,
564: p_region2 per_addresses.region_2%type,
565: p_postal_code per_addresses.postal_code%type);
566:

Line 563: p_region1 per_addresses.region_1%type,

559: p_addr_line2 per_addresses.address_line2%type,
560: p_addr_line3 per_addresses.address_line3%type,
561: p_twn_or_city per_addresses.town_or_city%type,
562: p_tel_number1 per_addresses.telephone_number_1%type,
563: p_region1 per_addresses.region_1%type,
564: p_region2 per_addresses.region_2%type,
565: p_postal_code per_addresses.postal_code%type);
566:
567: TYPE address_record is table of ADDRESS index by binary_integer;

Line 564: p_region2 per_addresses.region_2%type,

560: p_addr_line3 per_addresses.address_line3%type,
561: p_twn_or_city per_addresses.town_or_city%type,
562: p_tel_number1 per_addresses.telephone_number_1%type,
563: p_region1 per_addresses.region_1%type,
564: p_region2 per_addresses.region_2%type,
565: p_postal_code per_addresses.postal_code%type);
566:
567: TYPE address_record is table of ADDRESS index by binary_integer;
568:

Line 565: p_postal_code per_addresses.postal_code%type);

561: p_twn_or_city per_addresses.town_or_city%type,
562: p_tel_number1 per_addresses.telephone_number_1%type,
563: p_region1 per_addresses.region_1%type,
564: p_region2 per_addresses.region_2%type,
565: p_postal_code per_addresses.postal_code%type);
566:
567: TYPE address_record is table of ADDRESS index by binary_integer;
568:
569: TYPE PHONE IS RECORD

Line 636: FROM per_addresses

632: Telephone_Number_1,
633: Region_1,
634: Region_2,
635: Postal_Code
636: FROM per_addresses
637: where person_id = p_person_id
638: and date_from between P_Eff_St_Dt and P_Eff_End_Dt;
639:
640: Cursor csr_phone_data(P_Person_Id Number,P_Eff_St_Dt Date,P_Eff_End_Dt Date) Is