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

Line 180: l_address_line1 per_addresses.address_line1%TYPE;

176: IS
177: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_address_rec';
178: l_arch BOOLEAN;
179: --address details
180: l_address_line1 per_addresses.address_line1%TYPE;
181: l_address_line2 per_addresses.address_line2%TYPE;
182: l_address_line3 per_addresses.address_line3%TYPE;
183: l_address_line4 per_addresses.address_line3%TYPE;
184:

Line 181: l_address_line2 per_addresses.address_line2%TYPE;

177: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_address_rec';
178: l_arch BOOLEAN;
179: --address details
180: l_address_line1 per_addresses.address_line1%TYPE;
181: l_address_line2 per_addresses.address_line2%TYPE;
182: l_address_line3 per_addresses.address_line3%TYPE;
183: l_address_line4 per_addresses.address_line3%TYPE;
184:
185: CURSOR csr_address

Line 182: l_address_line3 per_addresses.address_line3%TYPE;

178: l_arch BOOLEAN;
179: --address details
180: l_address_line1 per_addresses.address_line1%TYPE;
181: l_address_line2 per_addresses.address_line2%TYPE;
182: l_address_line3 per_addresses.address_line3%TYPE;
183: l_address_line4 per_addresses.address_line3%TYPE;
184:
185: CURSOR csr_address
186: IS

Line 183: l_address_line4 per_addresses.address_line3%TYPE;

179: --address details
180: l_address_line1 per_addresses.address_line1%TYPE;
181: l_address_line2 per_addresses.address_line2%TYPE;
182: l_address_line3 per_addresses.address_line3%TYPE;
183: l_address_line4 per_addresses.address_line3%TYPE;
184:
185: CURSOR csr_address
186: IS
187: SELECT upper(SUBSTR(trim(addr.address_line1),1,35)) addr1,

Line 193: FROM per_addresses addr

189: upper(SUBSTR(trim(addr.address_line3),1,35)) addr3,
190: SUBSTR(addr.postal_code,1,10) post_code,
191: upper(SUBSTR(trim(addr.town_or_city),1,35)) addr4,
192: upper(SUBSTR(trim(addr.country),1,35)) country
193: FROM per_addresses addr
194: WHERE addr.person_id = p_person_id
195: AND ( addr.primary_flag = 'Y'
196: OR addr.primary_flag IS NULL)
197: AND p_effective_date

Line 2651: l_address_line1 per_addresses.address_line1%TYPE;

2647: --Assignment Number
2648: l_assignment_number per_assignments_f.assignment_number%TYPE;
2649:
2650: -- Address details
2651: l_address_line1 per_addresses.address_line1%TYPE;
2652: l_address_line2 per_addresses.address_line2%TYPE;
2653: l_address_line3 per_addresses.address_line3%TYPE;
2654: l_address_line4 per_addresses.address_line3%TYPE;
2655: l_town_or_city per_addresses.town_or_city%TYPE;

Line 2652: l_address_line2 per_addresses.address_line2%TYPE;

2648: l_assignment_number per_assignments_f.assignment_number%TYPE;
2649:
2650: -- Address details
2651: l_address_line1 per_addresses.address_line1%TYPE;
2652: l_address_line2 per_addresses.address_line2%TYPE;
2653: l_address_line3 per_addresses.address_line3%TYPE;
2654: l_address_line4 per_addresses.address_line3%TYPE;
2655: l_town_or_city per_addresses.town_or_city%TYPE;
2656: l_postal_code per_addresses.postal_code%TYPE;

Line 2653: l_address_line3 per_addresses.address_line3%TYPE;

2649:
2650: -- Address details
2651: l_address_line1 per_addresses.address_line1%TYPE;
2652: l_address_line2 per_addresses.address_line2%TYPE;
2653: l_address_line3 per_addresses.address_line3%TYPE;
2654: l_address_line4 per_addresses.address_line3%TYPE;
2655: l_town_or_city per_addresses.town_or_city%TYPE;
2656: l_postal_code per_addresses.postal_code%TYPE;
2657: l_country per_addresses.country%TYPE;

Line 2654: l_address_line4 per_addresses.address_line3%TYPE;

2650: -- Address details
2651: l_address_line1 per_addresses.address_line1%TYPE;
2652: l_address_line2 per_addresses.address_line2%TYPE;
2653: l_address_line3 per_addresses.address_line3%TYPE;
2654: l_address_line4 per_addresses.address_line3%TYPE;
2655: l_town_or_city per_addresses.town_or_city%TYPE;
2656: l_postal_code per_addresses.postal_code%TYPE;
2657: l_country per_addresses.country%TYPE;
2658:

Line 2655: l_town_or_city per_addresses.town_or_city%TYPE;

2651: l_address_line1 per_addresses.address_line1%TYPE;
2652: l_address_line2 per_addresses.address_line2%TYPE;
2653: l_address_line3 per_addresses.address_line3%TYPE;
2654: l_address_line4 per_addresses.address_line3%TYPE;
2655: l_town_or_city per_addresses.town_or_city%TYPE;
2656: l_postal_code per_addresses.postal_code%TYPE;
2657: l_country per_addresses.country%TYPE;
2658:
2659: -- Person details

Line 2656: l_postal_code per_addresses.postal_code%TYPE;

2652: l_address_line2 per_addresses.address_line2%TYPE;
2653: l_address_line3 per_addresses.address_line3%TYPE;
2654: l_address_line4 per_addresses.address_line3%TYPE;
2655: l_town_or_city per_addresses.town_or_city%TYPE;
2656: l_postal_code per_addresses.postal_code%TYPE;
2657: l_country per_addresses.country%TYPE;
2658:
2659: -- Person details
2660: l_last_name per_people_f.last_name%TYPE;

Line 2657: l_country per_addresses.country%TYPE;

2653: l_address_line3 per_addresses.address_line3%TYPE;
2654: l_address_line4 per_addresses.address_line3%TYPE;
2655: l_town_or_city per_addresses.town_or_city%TYPE;
2656: l_postal_code per_addresses.postal_code%TYPE;
2657: l_country per_addresses.country%TYPE;
2658:
2659: -- Person details
2660: l_last_name per_people_f.last_name%TYPE;
2661: l_first_name per_people_f.first_name%TYPE;