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 1139: p_address_id per_addresses.address_id%type;

1135: p_eff_date VARCHAR2(100);
1136: p_date date;
1137: myparameters wf_parameter_list_t;
1138:
1139: p_address_id per_addresses.address_id%type;
1140: p_addr_date_from per_addresses.date_from%type;
1141:
1142: l_transaction_id Number :=0;
1143: l_transaction_id_canonical Varchar2(30);

Line 1140: p_addr_date_from per_addresses.date_from%type;

1136: p_date date;
1137: myparameters wf_parameter_list_t;
1138:
1139: p_address_id per_addresses.address_id%type;
1140: p_addr_date_from per_addresses.date_from%type;
1141:
1142: l_transaction_id Number :=0;
1143: l_transaction_id_canonical Varchar2(30);
1144:

Line 1146: is select person_id from per_addresses

1142: l_transaction_id Number :=0;
1143: l_transaction_id_canonical Varchar2(30);
1144:
1145: cursor csr_person_id(p_addr_id varchar2,p_eff_date date)
1146: is select person_id from per_addresses
1147: where address_id = p_addr_id
1148: and p_eff_date between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1149:
1150:

Line 1935: FROM PER_ALL_PEOPLE_F ppf,per_addresses paddr

1931: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1932: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1933: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
1934:
1935: FROM PER_ALL_PEOPLE_F ppf,per_addresses paddr
1936: where ppf.person_id = :1
1937: and ppf.person_id = paddr.person_id
1938: and paddr.address_id = :4
1939: AND :2 between nvl(paddr.date_from,:2) and nvl(paddr.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))

Line 2997: p_address_id per_addresses.address_id%type;

2993: p_date date;
2994: p_event_data clob;
2995: p_person_id per_all_people_f.person_id%type;
2996:
2997: p_address_id per_addresses.address_id%type;
2998: p_address_type per_addresses.address_type%type;
2999: p_addr_date_from per_addresses.date_from%type;
3000: p_addr_date_to per_addresses.date_to%type;
3001: p_addr_cntry per_addresses.country%type;

Line 2998: p_address_type per_addresses.address_type%type;

2994: p_event_data clob;
2995: p_person_id per_all_people_f.person_id%type;
2996:
2997: p_address_id per_addresses.address_id%type;
2998: p_address_type per_addresses.address_type%type;
2999: p_addr_date_from per_addresses.date_from%type;
3000: p_addr_date_to per_addresses.date_to%type;
3001: p_addr_cntry per_addresses.country%type;
3002: p_Addr_Line1 per_addresses.address_line1%type;

Line 2999: p_addr_date_from per_addresses.date_from%type;

2995: p_person_id per_all_people_f.person_id%type;
2996:
2997: p_address_id per_addresses.address_id%type;
2998: p_address_type per_addresses.address_type%type;
2999: p_addr_date_from per_addresses.date_from%type;
3000: p_addr_date_to per_addresses.date_to%type;
3001: p_addr_cntry per_addresses.country%type;
3002: p_Addr_Line1 per_addresses.address_line1%type;
3003: p_Addr_Line2 per_addresses.address_line2%type;

Line 3000: p_addr_date_to per_addresses.date_to%type;

2996:
2997: p_address_id per_addresses.address_id%type;
2998: p_address_type per_addresses.address_type%type;
2999: p_addr_date_from per_addresses.date_from%type;
3000: p_addr_date_to per_addresses.date_to%type;
3001: p_addr_cntry per_addresses.country%type;
3002: p_Addr_Line1 per_addresses.address_line1%type;
3003: p_Addr_Line2 per_addresses.address_line2%type;
3004: p_Addr_Line3 per_addresses.address_line3%type;

Line 3001: p_addr_cntry per_addresses.country%type;

2997: p_address_id per_addresses.address_id%type;
2998: p_address_type per_addresses.address_type%type;
2999: p_addr_date_from per_addresses.date_from%type;
3000: p_addr_date_to per_addresses.date_to%type;
3001: p_addr_cntry per_addresses.country%type;
3002: p_Addr_Line1 per_addresses.address_line1%type;
3003: p_Addr_Line2 per_addresses.address_line2%type;
3004: p_Addr_Line3 per_addresses.address_line3%type;
3005: p_Town_Or_City per_addresses.town_or_city%type;

Line 3002: p_Addr_Line1 per_addresses.address_line1%type;

2998: p_address_type per_addresses.address_type%type;
2999: p_addr_date_from per_addresses.date_from%type;
3000: p_addr_date_to per_addresses.date_to%type;
3001: p_addr_cntry per_addresses.country%type;
3002: p_Addr_Line1 per_addresses.address_line1%type;
3003: p_Addr_Line2 per_addresses.address_line2%type;
3004: p_Addr_Line3 per_addresses.address_line3%type;
3005: p_Town_Or_City per_addresses.town_or_city%type;
3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;

Line 3003: p_Addr_Line2 per_addresses.address_line2%type;

2999: p_addr_date_from per_addresses.date_from%type;
3000: p_addr_date_to per_addresses.date_to%type;
3001: p_addr_cntry per_addresses.country%type;
3002: p_Addr_Line1 per_addresses.address_line1%type;
3003: p_Addr_Line2 per_addresses.address_line2%type;
3004: p_Addr_Line3 per_addresses.address_line3%type;
3005: p_Town_Or_City per_addresses.town_or_city%type;
3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;
3007: p_Region_1 per_addresses.region_1%type;

Line 3004: p_Addr_Line3 per_addresses.address_line3%type;

3000: p_addr_date_to per_addresses.date_to%type;
3001: p_addr_cntry per_addresses.country%type;
3002: p_Addr_Line1 per_addresses.address_line1%type;
3003: p_Addr_Line2 per_addresses.address_line2%type;
3004: p_Addr_Line3 per_addresses.address_line3%type;
3005: p_Town_Or_City per_addresses.town_or_city%type;
3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;
3007: p_Region_1 per_addresses.region_1%type;
3008: p_Region_2 per_addresses.region_2%type;

Line 3005: p_Town_Or_City per_addresses.town_or_city%type;

3001: p_addr_cntry per_addresses.country%type;
3002: p_Addr_Line1 per_addresses.address_line1%type;
3003: p_Addr_Line2 per_addresses.address_line2%type;
3004: p_Addr_Line3 per_addresses.address_line3%type;
3005: p_Town_Or_City per_addresses.town_or_city%type;
3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;
3007: p_Region_1 per_addresses.region_1%type;
3008: p_Region_2 per_addresses.region_2%type;
3009: p_Postal_Code per_addresses.postal_code%type;

Line 3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;

3002: p_Addr_Line1 per_addresses.address_line1%type;
3003: p_Addr_Line2 per_addresses.address_line2%type;
3004: p_Addr_Line3 per_addresses.address_line3%type;
3005: p_Town_Or_City per_addresses.town_or_city%type;
3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;
3007: p_Region_1 per_addresses.region_1%type;
3008: p_Region_2 per_addresses.region_2%type;
3009: p_Postal_Code per_addresses.postal_code%type;
3010: p_Primary_Flag per_addresses.postal_code%type;

Line 3007: p_Region_1 per_addresses.region_1%type;

3003: p_Addr_Line2 per_addresses.address_line2%type;
3004: p_Addr_Line3 per_addresses.address_line3%type;
3005: p_Town_Or_City per_addresses.town_or_city%type;
3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;
3007: p_Region_1 per_addresses.region_1%type;
3008: p_Region_2 per_addresses.region_2%type;
3009: p_Postal_Code per_addresses.postal_code%type;
3010: p_Primary_Flag per_addresses.postal_code%type;
3011:

Line 3008: p_Region_2 per_addresses.region_2%type;

3004: p_Addr_Line3 per_addresses.address_line3%type;
3005: p_Town_Or_City per_addresses.town_or_city%type;
3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;
3007: p_Region_1 per_addresses.region_1%type;
3008: p_Region_2 per_addresses.region_2%type;
3009: p_Postal_Code per_addresses.postal_code%type;
3010: p_Primary_Flag per_addresses.postal_code%type;
3011:
3012: p_address_type_t per_addresses.address_type%type;

Line 3009: p_Postal_Code per_addresses.postal_code%type;

3005: p_Town_Or_City per_addresses.town_or_city%type;
3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;
3007: p_Region_1 per_addresses.region_1%type;
3008: p_Region_2 per_addresses.region_2%type;
3009: p_Postal_Code per_addresses.postal_code%type;
3010: p_Primary_Flag per_addresses.postal_code%type;
3011:
3012: p_address_type_t per_addresses.address_type%type;
3013: p_addr_date_from_t per_addresses.date_from%type;

Line 3010: p_Primary_Flag per_addresses.postal_code%type;

3006: p_Tel_Num_1 per_addresses.telephone_number_1%type;
3007: p_Region_1 per_addresses.region_1%type;
3008: p_Region_2 per_addresses.region_2%type;
3009: p_Postal_Code per_addresses.postal_code%type;
3010: p_Primary_Flag per_addresses.postal_code%type;
3011:
3012: p_address_type_t per_addresses.address_type%type;
3013: p_addr_date_from_t per_addresses.date_from%type;
3014: p_addr_date_to_t per_addresses.date_to%type;

Line 3012: p_address_type_t per_addresses.address_type%type;

3008: p_Region_2 per_addresses.region_2%type;
3009: p_Postal_Code per_addresses.postal_code%type;
3010: p_Primary_Flag per_addresses.postal_code%type;
3011:
3012: p_address_type_t per_addresses.address_type%type;
3013: p_addr_date_from_t per_addresses.date_from%type;
3014: p_addr_date_to_t per_addresses.date_to%type;
3015: p_addr_cntry_t per_addresses.country%type;
3016: p_Addr_Line1_t per_addresses.address_line1%type;

Line 3013: p_addr_date_from_t per_addresses.date_from%type;

3009: p_Postal_Code per_addresses.postal_code%type;
3010: p_Primary_Flag per_addresses.postal_code%type;
3011:
3012: p_address_type_t per_addresses.address_type%type;
3013: p_addr_date_from_t per_addresses.date_from%type;
3014: p_addr_date_to_t per_addresses.date_to%type;
3015: p_addr_cntry_t per_addresses.country%type;
3016: p_Addr_Line1_t per_addresses.address_line1%type;
3017: p_Addr_Line2_t per_addresses.address_line2%type;

Line 3014: p_addr_date_to_t per_addresses.date_to%type;

3010: p_Primary_Flag per_addresses.postal_code%type;
3011:
3012: p_address_type_t per_addresses.address_type%type;
3013: p_addr_date_from_t per_addresses.date_from%type;
3014: p_addr_date_to_t per_addresses.date_to%type;
3015: p_addr_cntry_t per_addresses.country%type;
3016: p_Addr_Line1_t per_addresses.address_line1%type;
3017: p_Addr_Line2_t per_addresses.address_line2%type;
3018: p_Addr_Line3_t per_addresses.address_line3%type;

Line 3015: p_addr_cntry_t per_addresses.country%type;

3011:
3012: p_address_type_t per_addresses.address_type%type;
3013: p_addr_date_from_t per_addresses.date_from%type;
3014: p_addr_date_to_t per_addresses.date_to%type;
3015: p_addr_cntry_t per_addresses.country%type;
3016: p_Addr_Line1_t per_addresses.address_line1%type;
3017: p_Addr_Line2_t per_addresses.address_line2%type;
3018: p_Addr_Line3_t per_addresses.address_line3%type;
3019: p_Town_Or_City_t per_addresses.town_or_city%type;

Line 3016: p_Addr_Line1_t per_addresses.address_line1%type;

3012: p_address_type_t per_addresses.address_type%type;
3013: p_addr_date_from_t per_addresses.date_from%type;
3014: p_addr_date_to_t per_addresses.date_to%type;
3015: p_addr_cntry_t per_addresses.country%type;
3016: p_Addr_Line1_t per_addresses.address_line1%type;
3017: p_Addr_Line2_t per_addresses.address_line2%type;
3018: p_Addr_Line3_t per_addresses.address_line3%type;
3019: p_Town_Or_City_t per_addresses.town_or_city%type;
3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;

Line 3017: p_Addr_Line2_t per_addresses.address_line2%type;

3013: p_addr_date_from_t per_addresses.date_from%type;
3014: p_addr_date_to_t per_addresses.date_to%type;
3015: p_addr_cntry_t per_addresses.country%type;
3016: p_Addr_Line1_t per_addresses.address_line1%type;
3017: p_Addr_Line2_t per_addresses.address_line2%type;
3018: p_Addr_Line3_t per_addresses.address_line3%type;
3019: p_Town_Or_City_t per_addresses.town_or_city%type;
3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
3021: p_Region_1_t per_addresses.region_1%type;

Line 3018: p_Addr_Line3_t per_addresses.address_line3%type;

3014: p_addr_date_to_t per_addresses.date_to%type;
3015: p_addr_cntry_t per_addresses.country%type;
3016: p_Addr_Line1_t per_addresses.address_line1%type;
3017: p_Addr_Line2_t per_addresses.address_line2%type;
3018: p_Addr_Line3_t per_addresses.address_line3%type;
3019: p_Town_Or_City_t per_addresses.town_or_city%type;
3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
3021: p_Region_1_t per_addresses.region_1%type;
3022: p_Region_2_t per_addresses.region_2%type;

Line 3019: p_Town_Or_City_t per_addresses.town_or_city%type;

3015: p_addr_cntry_t per_addresses.country%type;
3016: p_Addr_Line1_t per_addresses.address_line1%type;
3017: p_Addr_Line2_t per_addresses.address_line2%type;
3018: p_Addr_Line3_t per_addresses.address_line3%type;
3019: p_Town_Or_City_t per_addresses.town_or_city%type;
3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
3021: p_Region_1_t per_addresses.region_1%type;
3022: p_Region_2_t per_addresses.region_2%type;
3023: p_Postal_Code_t per_addresses.postal_code%type;

Line 3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;

3016: p_Addr_Line1_t per_addresses.address_line1%type;
3017: p_Addr_Line2_t per_addresses.address_line2%type;
3018: p_Addr_Line3_t per_addresses.address_line3%type;
3019: p_Town_Or_City_t per_addresses.town_or_city%type;
3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
3021: p_Region_1_t per_addresses.region_1%type;
3022: p_Region_2_t per_addresses.region_2%type;
3023: p_Postal_Code_t per_addresses.postal_code%type;
3024: p_Primary_Flag_t per_addresses.postal_code%type;

Line 3021: p_Region_1_t per_addresses.region_1%type;

3017: p_Addr_Line2_t per_addresses.address_line2%type;
3018: p_Addr_Line3_t per_addresses.address_line3%type;
3019: p_Town_Or_City_t per_addresses.town_or_city%type;
3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
3021: p_Region_1_t per_addresses.region_1%type;
3022: p_Region_2_t per_addresses.region_2%type;
3023: p_Postal_Code_t per_addresses.postal_code%type;
3024: p_Primary_Flag_t per_addresses.postal_code%type;
3025:

Line 3022: p_Region_2_t per_addresses.region_2%type;

3018: p_Addr_Line3_t per_addresses.address_line3%type;
3019: p_Town_Or_City_t per_addresses.town_or_city%type;
3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
3021: p_Region_1_t per_addresses.region_1%type;
3022: p_Region_2_t per_addresses.region_2%type;
3023: p_Postal_Code_t per_addresses.postal_code%type;
3024: p_Primary_Flag_t per_addresses.postal_code%type;
3025:
3026:

Line 3023: p_Postal_Code_t per_addresses.postal_code%type;

3019: p_Town_Or_City_t per_addresses.town_or_city%type;
3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
3021: p_Region_1_t per_addresses.region_1%type;
3022: p_Region_2_t per_addresses.region_2%type;
3023: p_Postal_Code_t per_addresses.postal_code%type;
3024: p_Primary_Flag_t per_addresses.postal_code%type;
3025:
3026:
3027: l_transaction_id_canonical Varchar2(30);

Line 3024: p_Primary_Flag_t per_addresses.postal_code%type;

3020: p_Tel_Num_1_t per_addresses.telephone_number_1%type;
3021: p_Region_1_t per_addresses.region_1%type;
3022: p_Region_2_t per_addresses.region_2%type;
3023: p_Postal_Code_t per_addresses.postal_code%type;
3024: p_Primary_Flag_t per_addresses.postal_code%type;
3025:
3026:
3027: l_transaction_id_canonical Varchar2(30);
3028: l_transaction_id Number;

Line 3046: FROM per_addresses

3042: Region_1,
3043: Region_2,
3044: Postal_Code,
3045: Primary_flag
3046: FROM per_addresses
3047: where person_id = p_person_id
3048: and address_id = p_address_id
3049: and P_Eff_St_Dt between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
3050: