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

Line 989: p_address_id per_addresses.address_id%type;

985: p_eff_date VARCHAR2(100);
986: p_date date;
987: myparameters wf_parameter_list_t;
988:
989: p_address_id per_addresses.address_id%type;
990: p_addr_date_from per_addresses.date_from%type;
991:
992: cursor csr_person_id(p_addr_id varchar2,p_eff_date date)
993: is select person_id from per_addresses

Line 990: p_addr_date_from per_addresses.date_from%type;

986: p_date date;
987: myparameters wf_parameter_list_t;
988:
989: p_address_id per_addresses.address_id%type;
990: p_addr_date_from per_addresses.date_from%type;
991:
992: cursor csr_person_id(p_addr_id varchar2,p_eff_date date)
993: is select person_id from per_addresses
994: where address_id = p_addr_id

Line 993: is select person_id from per_addresses

989: p_address_id per_addresses.address_id%type;
990: p_addr_date_from per_addresses.date_from%type;
991:
992: cursor csr_person_id(p_addr_id varchar2,p_eff_date date)
993: is select person_id from per_addresses
994: where address_id = p_addr_id
995: and p_eff_date between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
996:
997:

Line 1753: FROM PER_ALL_PEOPLE_F ppf,per_addresses paddr

1749: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1750: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1751: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
1752:
1753: FROM PER_ALL_PEOPLE_F ppf,per_addresses paddr
1754: where ppf.person_id = :1
1755: and ppf.person_id = paddr.person_id
1756: and paddr.address_id = :4
1757: AND :2 between nvl(paddr.date_from,:2) and nvl(paddr.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))

Line 2788: p_address_id per_addresses.address_id%type;

2784: p_date date;
2785: p_event_data clob;
2786: p_person_id per_all_people_f.person_id%type;
2787:
2788: p_address_id per_addresses.address_id%type;
2789: p_address_type per_addresses.address_type%type;
2790: p_addr_date_from per_addresses.date_from%type;
2791: p_addr_date_to per_addresses.date_to%type;
2792: p_addr_cntry per_addresses.country%type;

Line 2789: p_address_type per_addresses.address_type%type;

2785: p_event_data clob;
2786: p_person_id per_all_people_f.person_id%type;
2787:
2788: p_address_id per_addresses.address_id%type;
2789: p_address_type per_addresses.address_type%type;
2790: p_addr_date_from per_addresses.date_from%type;
2791: p_addr_date_to per_addresses.date_to%type;
2792: p_addr_cntry per_addresses.country%type;
2793: p_Addr_Line1 per_addresses.address_line1%type;

Line 2790: p_addr_date_from per_addresses.date_from%type;

2786: p_person_id per_all_people_f.person_id%type;
2787:
2788: p_address_id per_addresses.address_id%type;
2789: p_address_type per_addresses.address_type%type;
2790: p_addr_date_from per_addresses.date_from%type;
2791: p_addr_date_to per_addresses.date_to%type;
2792: p_addr_cntry per_addresses.country%type;
2793: p_Addr_Line1 per_addresses.address_line1%type;
2794: p_Addr_Line2 per_addresses.address_line2%type;

Line 2791: p_addr_date_to per_addresses.date_to%type;

2787:
2788: p_address_id per_addresses.address_id%type;
2789: p_address_type per_addresses.address_type%type;
2790: p_addr_date_from per_addresses.date_from%type;
2791: p_addr_date_to per_addresses.date_to%type;
2792: p_addr_cntry per_addresses.country%type;
2793: p_Addr_Line1 per_addresses.address_line1%type;
2794: p_Addr_Line2 per_addresses.address_line2%type;
2795: p_Addr_Line3 per_addresses.address_line3%type;

Line 2792: p_addr_cntry per_addresses.country%type;

2788: p_address_id per_addresses.address_id%type;
2789: p_address_type per_addresses.address_type%type;
2790: p_addr_date_from per_addresses.date_from%type;
2791: p_addr_date_to per_addresses.date_to%type;
2792: p_addr_cntry per_addresses.country%type;
2793: p_Addr_Line1 per_addresses.address_line1%type;
2794: p_Addr_Line2 per_addresses.address_line2%type;
2795: p_Addr_Line3 per_addresses.address_line3%type;
2796: p_Town_Or_City per_addresses.town_or_city%type;

Line 2793: p_Addr_Line1 per_addresses.address_line1%type;

2789: p_address_type per_addresses.address_type%type;
2790: p_addr_date_from per_addresses.date_from%type;
2791: p_addr_date_to per_addresses.date_to%type;
2792: p_addr_cntry per_addresses.country%type;
2793: p_Addr_Line1 per_addresses.address_line1%type;
2794: p_Addr_Line2 per_addresses.address_line2%type;
2795: p_Addr_Line3 per_addresses.address_line3%type;
2796: p_Town_Or_City per_addresses.town_or_city%type;
2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;

Line 2794: p_Addr_Line2 per_addresses.address_line2%type;

2790: p_addr_date_from per_addresses.date_from%type;
2791: p_addr_date_to per_addresses.date_to%type;
2792: p_addr_cntry per_addresses.country%type;
2793: p_Addr_Line1 per_addresses.address_line1%type;
2794: p_Addr_Line2 per_addresses.address_line2%type;
2795: p_Addr_Line3 per_addresses.address_line3%type;
2796: p_Town_Or_City per_addresses.town_or_city%type;
2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;
2798: p_Region_1 per_addresses.region_1%type;

Line 2795: p_Addr_Line3 per_addresses.address_line3%type;

2791: p_addr_date_to per_addresses.date_to%type;
2792: p_addr_cntry per_addresses.country%type;
2793: p_Addr_Line1 per_addresses.address_line1%type;
2794: p_Addr_Line2 per_addresses.address_line2%type;
2795: p_Addr_Line3 per_addresses.address_line3%type;
2796: p_Town_Or_City per_addresses.town_or_city%type;
2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;
2798: p_Region_1 per_addresses.region_1%type;
2799: p_Region_2 per_addresses.region_2%type;

Line 2796: p_Town_Or_City per_addresses.town_or_city%type;

2792: p_addr_cntry per_addresses.country%type;
2793: p_Addr_Line1 per_addresses.address_line1%type;
2794: p_Addr_Line2 per_addresses.address_line2%type;
2795: p_Addr_Line3 per_addresses.address_line3%type;
2796: p_Town_Or_City per_addresses.town_or_city%type;
2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;
2798: p_Region_1 per_addresses.region_1%type;
2799: p_Region_2 per_addresses.region_2%type;
2800: p_Postal_Code per_addresses.postal_code%type;

Line 2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;

2793: p_Addr_Line1 per_addresses.address_line1%type;
2794: p_Addr_Line2 per_addresses.address_line2%type;
2795: p_Addr_Line3 per_addresses.address_line3%type;
2796: p_Town_Or_City per_addresses.town_or_city%type;
2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;
2798: p_Region_1 per_addresses.region_1%type;
2799: p_Region_2 per_addresses.region_2%type;
2800: p_Postal_Code per_addresses.postal_code%type;
2801:

Line 2798: p_Region_1 per_addresses.region_1%type;

2794: p_Addr_Line2 per_addresses.address_line2%type;
2795: p_Addr_Line3 per_addresses.address_line3%type;
2796: p_Town_Or_City per_addresses.town_or_city%type;
2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;
2798: p_Region_1 per_addresses.region_1%type;
2799: p_Region_2 per_addresses.region_2%type;
2800: p_Postal_Code per_addresses.postal_code%type;
2801:
2802: p_address_type_t per_addresses.address_type%type;

Line 2799: p_Region_2 per_addresses.region_2%type;

2795: p_Addr_Line3 per_addresses.address_line3%type;
2796: p_Town_Or_City per_addresses.town_or_city%type;
2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;
2798: p_Region_1 per_addresses.region_1%type;
2799: p_Region_2 per_addresses.region_2%type;
2800: p_Postal_Code per_addresses.postal_code%type;
2801:
2802: p_address_type_t per_addresses.address_type%type;
2803: p_addr_date_from_t per_addresses.date_from%type;

Line 2800: p_Postal_Code per_addresses.postal_code%type;

2796: p_Town_Or_City per_addresses.town_or_city%type;
2797: p_Tel_Num_1 per_addresses.telephone_number_1%type;
2798: p_Region_1 per_addresses.region_1%type;
2799: p_Region_2 per_addresses.region_2%type;
2800: p_Postal_Code per_addresses.postal_code%type;
2801:
2802: p_address_type_t per_addresses.address_type%type;
2803: p_addr_date_from_t per_addresses.date_from%type;
2804: p_addr_date_to_t per_addresses.date_to%type;

Line 2802: p_address_type_t per_addresses.address_type%type;

2798: p_Region_1 per_addresses.region_1%type;
2799: p_Region_2 per_addresses.region_2%type;
2800: p_Postal_Code per_addresses.postal_code%type;
2801:
2802: p_address_type_t per_addresses.address_type%type;
2803: p_addr_date_from_t per_addresses.date_from%type;
2804: p_addr_date_to_t per_addresses.date_to%type;
2805: p_addr_cntry_t per_addresses.country%type;
2806: p_Addr_Line1_t per_addresses.address_line1%type;

Line 2803: p_addr_date_from_t per_addresses.date_from%type;

2799: p_Region_2 per_addresses.region_2%type;
2800: p_Postal_Code per_addresses.postal_code%type;
2801:
2802: p_address_type_t per_addresses.address_type%type;
2803: p_addr_date_from_t per_addresses.date_from%type;
2804: p_addr_date_to_t per_addresses.date_to%type;
2805: p_addr_cntry_t per_addresses.country%type;
2806: p_Addr_Line1_t per_addresses.address_line1%type;
2807: p_Addr_Line2_t per_addresses.address_line2%type;

Line 2804: p_addr_date_to_t per_addresses.date_to%type;

2800: p_Postal_Code per_addresses.postal_code%type;
2801:
2802: p_address_type_t per_addresses.address_type%type;
2803: p_addr_date_from_t per_addresses.date_from%type;
2804: p_addr_date_to_t per_addresses.date_to%type;
2805: p_addr_cntry_t per_addresses.country%type;
2806: p_Addr_Line1_t per_addresses.address_line1%type;
2807: p_Addr_Line2_t per_addresses.address_line2%type;
2808: p_Addr_Line3_t per_addresses.address_line3%type;

Line 2805: p_addr_cntry_t per_addresses.country%type;

2801:
2802: p_address_type_t per_addresses.address_type%type;
2803: p_addr_date_from_t per_addresses.date_from%type;
2804: p_addr_date_to_t per_addresses.date_to%type;
2805: p_addr_cntry_t per_addresses.country%type;
2806: p_Addr_Line1_t per_addresses.address_line1%type;
2807: p_Addr_Line2_t per_addresses.address_line2%type;
2808: p_Addr_Line3_t per_addresses.address_line3%type;
2809: p_Town_Or_City_t per_addresses.town_or_city%type;

Line 2806: p_Addr_Line1_t per_addresses.address_line1%type;

2802: p_address_type_t per_addresses.address_type%type;
2803: p_addr_date_from_t per_addresses.date_from%type;
2804: p_addr_date_to_t per_addresses.date_to%type;
2805: p_addr_cntry_t per_addresses.country%type;
2806: p_Addr_Line1_t per_addresses.address_line1%type;
2807: p_Addr_Line2_t per_addresses.address_line2%type;
2808: p_Addr_Line3_t per_addresses.address_line3%type;
2809: p_Town_Or_City_t per_addresses.town_or_city%type;
2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;

Line 2807: p_Addr_Line2_t per_addresses.address_line2%type;

2803: p_addr_date_from_t per_addresses.date_from%type;
2804: p_addr_date_to_t per_addresses.date_to%type;
2805: p_addr_cntry_t per_addresses.country%type;
2806: p_Addr_Line1_t per_addresses.address_line1%type;
2807: p_Addr_Line2_t per_addresses.address_line2%type;
2808: p_Addr_Line3_t per_addresses.address_line3%type;
2809: p_Town_Or_City_t per_addresses.town_or_city%type;
2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
2811: p_Region_1_t per_addresses.region_1%type;

Line 2808: p_Addr_Line3_t per_addresses.address_line3%type;

2804: p_addr_date_to_t per_addresses.date_to%type;
2805: p_addr_cntry_t per_addresses.country%type;
2806: p_Addr_Line1_t per_addresses.address_line1%type;
2807: p_Addr_Line2_t per_addresses.address_line2%type;
2808: p_Addr_Line3_t per_addresses.address_line3%type;
2809: p_Town_Or_City_t per_addresses.town_or_city%type;
2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
2811: p_Region_1_t per_addresses.region_1%type;
2812: p_Region_2_t per_addresses.region_2%type;

Line 2809: p_Town_Or_City_t per_addresses.town_or_city%type;

2805: p_addr_cntry_t per_addresses.country%type;
2806: p_Addr_Line1_t per_addresses.address_line1%type;
2807: p_Addr_Line2_t per_addresses.address_line2%type;
2808: p_Addr_Line3_t per_addresses.address_line3%type;
2809: p_Town_Or_City_t per_addresses.town_or_city%type;
2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
2811: p_Region_1_t per_addresses.region_1%type;
2812: p_Region_2_t per_addresses.region_2%type;
2813: p_Postal_Code_t per_addresses.postal_code%type;

Line 2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;

2806: p_Addr_Line1_t per_addresses.address_line1%type;
2807: p_Addr_Line2_t per_addresses.address_line2%type;
2808: p_Addr_Line3_t per_addresses.address_line3%type;
2809: p_Town_Or_City_t per_addresses.town_or_city%type;
2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
2811: p_Region_1_t per_addresses.region_1%type;
2812: p_Region_2_t per_addresses.region_2%type;
2813: p_Postal_Code_t per_addresses.postal_code%type;
2814:

Line 2811: p_Region_1_t per_addresses.region_1%type;

2807: p_Addr_Line2_t per_addresses.address_line2%type;
2808: p_Addr_Line3_t per_addresses.address_line3%type;
2809: p_Town_Or_City_t per_addresses.town_or_city%type;
2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
2811: p_Region_1_t per_addresses.region_1%type;
2812: p_Region_2_t per_addresses.region_2%type;
2813: p_Postal_Code_t per_addresses.postal_code%type;
2814:
2815: Cursor Csr_Address_Data(P_Person_Id Number,P_Address_Id number,P_Eff_St_Dt Date ) Is

Line 2812: p_Region_2_t per_addresses.region_2%type;

2808: p_Addr_Line3_t per_addresses.address_line3%type;
2809: p_Town_Or_City_t per_addresses.town_or_city%type;
2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
2811: p_Region_1_t per_addresses.region_1%type;
2812: p_Region_2_t per_addresses.region_2%type;
2813: p_Postal_Code_t per_addresses.postal_code%type;
2814:
2815: Cursor Csr_Address_Data(P_Person_Id Number,P_Address_Id number,P_Eff_St_Dt Date ) Is
2816: Select

Line 2813: p_Postal_Code_t per_addresses.postal_code%type;

2809: p_Town_Or_City_t per_addresses.town_or_city%type;
2810: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
2811: p_Region_1_t per_addresses.region_1%type;
2812: p_Region_2_t per_addresses.region_2%type;
2813: p_Postal_Code_t per_addresses.postal_code%type;
2814:
2815: Cursor Csr_Address_Data(P_Person_Id Number,P_Address_Id number,P_Eff_St_Dt Date ) Is
2816: Select
2817: Address_Type,

Line 2829: FROM per_addresses

2825: Telephone_Number_1,
2826: Region_1,
2827: Region_2,
2828: Postal_Code
2829: FROM per_addresses
2830: where person_id = p_person_id
2831: and address_id = p_address_id
2832: and P_Eff_St_Dt between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
2833: