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.PAY_NL_ABP_ARCHIVE dependencies on PER_ADDRESSES

Line 2905: FROM per_addresses_v

2901: SELECT decode (country
2902: ,'NL'
2903: ,'Y'
2904: ,'N')
2905: FROM per_addresses_v
2906: WHERE person_id = c_person_id
2907: AND c_effective_date BETWEEN date_from
2908: AND nvl (date_to
2909: ,hr_api.g_eot)

Line 2987: FROM per_addresses_v pad

2983: ,substr(pad.address_line3, 1, 35) glb_location --NL_GLB Location
2984: ,upper(pad.postal_code) postal --Postal Code
2985: ,pad.town_or_city city --City
2986: ,pad.add_information16 iso --NL_GLB ISO Country code
2987: FROM per_addresses_v pad
2988: WHERE pad.person_id = c_person_id
2989: AND pad.primary_flag = 'Y'
2990: AND c_effective_date BETWEEN pad.date_from
2991: AND nvl (pad.date_to

Line 3301: l_street per_addresses.address_line1%TYPE := NULL;

3297: l_individual_exem VARCHAR2(1) := NULL;
3298: l_kind_emp VARCHAR2(2) := 'WN';
3299: l_income_code VARCHAR2(2) := NULL;
3300:
3301: l_street per_addresses.address_line1%TYPE := NULL;
3302: l_house_number per_addresses.address_line2%TYPE := NULL;
3303: l_house_number_addition per_addresses.add_information14%TYPE := NULL;
3304: l_location per_addresses.address_line3%TYPE := NULL;
3305: l_postal_code per_addresses.postal_code%TYPE := NULL;

Line 3302: l_house_number per_addresses.address_line2%TYPE := NULL;

3298: l_kind_emp VARCHAR2(2) := 'WN';
3299: l_income_code VARCHAR2(2) := NULL;
3300:
3301: l_street per_addresses.address_line1%TYPE := NULL;
3302: l_house_number per_addresses.address_line2%TYPE := NULL;
3303: l_house_number_addition per_addresses.add_information14%TYPE := NULL;
3304: l_location per_addresses.address_line3%TYPE := NULL;
3305: l_postal_code per_addresses.postal_code%TYPE := NULL;
3306: l_city per_addresses.town_or_city%TYPE := NULL;

Line 3303: l_house_number_addition per_addresses.add_information14%TYPE := NULL;

3299: l_income_code VARCHAR2(2) := NULL;
3300:
3301: l_street per_addresses.address_line1%TYPE := NULL;
3302: l_house_number per_addresses.address_line2%TYPE := NULL;
3303: l_house_number_addition per_addresses.add_information14%TYPE := NULL;
3304: l_location per_addresses.address_line3%TYPE := NULL;
3305: l_postal_code per_addresses.postal_code%TYPE := NULL;
3306: l_city per_addresses.town_or_city%TYPE := NULL;
3307: l_region per_addresses.address_line1%TYPE := NULL;

Line 3304: l_location per_addresses.address_line3%TYPE := NULL;

3300:
3301: l_street per_addresses.address_line1%TYPE := NULL;
3302: l_house_number per_addresses.address_line2%TYPE := NULL;
3303: l_house_number_addition per_addresses.add_information14%TYPE := NULL;
3304: l_location per_addresses.address_line3%TYPE := NULL;
3305: l_postal_code per_addresses.postal_code%TYPE := NULL;
3306: l_city per_addresses.town_or_city%TYPE := NULL;
3307: l_region per_addresses.address_line1%TYPE := NULL;
3308: l_iso per_addresses.add_information15%TYPE := NULL;

Line 3305: l_postal_code per_addresses.postal_code%TYPE := NULL;

3301: l_street per_addresses.address_line1%TYPE := NULL;
3302: l_house_number per_addresses.address_line2%TYPE := NULL;
3303: l_house_number_addition per_addresses.add_information14%TYPE := NULL;
3304: l_location per_addresses.address_line3%TYPE := NULL;
3305: l_postal_code per_addresses.postal_code%TYPE := NULL;
3306: l_city per_addresses.town_or_city%TYPE := NULL;
3307: l_region per_addresses.address_line1%TYPE := NULL;
3308: l_iso per_addresses.add_information15%TYPE := NULL;
3309:

Line 3306: l_city per_addresses.town_or_city%TYPE := NULL;

3302: l_house_number per_addresses.address_line2%TYPE := NULL;
3303: l_house_number_addition per_addresses.add_information14%TYPE := NULL;
3304: l_location per_addresses.address_line3%TYPE := NULL;
3305: l_postal_code per_addresses.postal_code%TYPE := NULL;
3306: l_city per_addresses.town_or_city%TYPE := NULL;
3307: l_region per_addresses.address_line1%TYPE := NULL;
3308: l_iso per_addresses.add_information15%TYPE := NULL;
3309:
3310: l_asg_start_date DATE;

Line 3307: l_region per_addresses.address_line1%TYPE := NULL;

3303: l_house_number_addition per_addresses.add_information14%TYPE := NULL;
3304: l_location per_addresses.address_line3%TYPE := NULL;
3305: l_postal_code per_addresses.postal_code%TYPE := NULL;
3306: l_city per_addresses.town_or_city%TYPE := NULL;
3307: l_region per_addresses.address_line1%TYPE := NULL;
3308: l_iso per_addresses.add_information15%TYPE := NULL;
3309:
3310: l_asg_start_date DATE;
3311: l_asg_end_date DATE;

Line 3308: l_iso per_addresses.add_information15%TYPE := NULL;

3304: l_location per_addresses.address_line3%TYPE := NULL;
3305: l_postal_code per_addresses.postal_code%TYPE := NULL;
3306: l_city per_addresses.town_or_city%TYPE := NULL;
3307: l_region per_addresses.address_line1%TYPE := NULL;
3308: l_iso per_addresses.add_information15%TYPE := NULL;
3309:
3310: l_asg_start_date DATE;
3311: l_asg_end_date DATE;
3312: l_asg_term_date DATE:=NULL;