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

Line 336: FROM per_addresses pad,

332: ltrim(rtrim(pad.town_or_city)) town_or_city,
333: substr(l.meaning,1,27) county,
334: substr(pad.postal_code,1,8),
335: country
336: FROM per_addresses pad,
337: hr_lookups l
338: WHERE pad.person_id = p_person_id
339: AND pad.primary_flag = 'Y'
340: AND l.lookup_type(+) = 'GB_COUNTY'

Line 378: l_address_line1 per_addresses.address_line1%type;

374: l_pensioner_indicator VARCHAR2(1);
375: l_aggregated_paye_flag VARCHAR2(1);
376: l_multiple_asg_flag VARCHAR2(1);
377: l_employee_number per_all_people_f.employee_number%TYPE;
378: l_address_line1 per_addresses.address_line1%type;
379: l_address_line2 per_addresses.address_line2%type;
380: l_address_line3 per_addresses.address_line3%type;
381: l_town_or_city VARCHAR2(30);
382: l_county VARCHAR2(27);

Line 379: l_address_line2 per_addresses.address_line2%type;

375: l_aggregated_paye_flag VARCHAR2(1);
376: l_multiple_asg_flag VARCHAR2(1);
377: l_employee_number per_all_people_f.employee_number%TYPE;
378: l_address_line1 per_addresses.address_line1%type;
379: l_address_line2 per_addresses.address_line2%type;
380: l_address_line3 per_addresses.address_line3%type;
381: l_town_or_city VARCHAR2(30);
382: l_county VARCHAR2(27);
383: l_country_name fnd_territories_tl.territory_short_name%type;

Line 380: l_address_line3 per_addresses.address_line3%type;

376: l_multiple_asg_flag VARCHAR2(1);
377: l_employee_number per_all_people_f.employee_number%TYPE;
378: l_address_line1 per_addresses.address_line1%type;
379: l_address_line2 per_addresses.address_line2%type;
380: l_address_line3 per_addresses.address_line3%type;
381: l_town_or_city VARCHAR2(30);
382: l_county VARCHAR2(27);
383: l_country_name fnd_territories_tl.territory_short_name%type;
384: l_country per_addresses.country%type;

Line 384: l_country per_addresses.country%type;

380: l_address_line3 per_addresses.address_line3%type;
381: l_town_or_city VARCHAR2(30);
382: l_county VARCHAR2(27);
383: l_country_name fnd_territories_tl.territory_short_name%type;
384: l_country per_addresses.country%type;
385: l_postal_code VARCHAR2(8);
386: l_name_and_initials VARCHAR2(100);
387: l_profile_name_format VARCHAR2(100);
388: l_assignment_number VARCHAR2(40);