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

Line 2790: per_addresses a1,

2786: a1.region_3,
2787: a1.postal_code,
2788: a1.country
2789: from pay_action_information a,
2790: per_addresses a1,
2791: per_all_assignments_f per
2792: where per.assignment_id = p_assignment_id
2793: and p_asg_end_date between per.effective_start_date and per.effective_end_date
2794: and a1.person_id = per.person_id

Line 2797: from per_addresses a2

2793: and p_asg_end_date between per.effective_start_date and per.effective_end_date
2794: and a1.person_id = per.person_id
2795: /*
2796: and a1.date_from = (select max(a2.date_from)
2797: from per_addresses a2
2798: where a2.primary_flag = 'Y'
2799: and a2.person_id = a1.person_id)
2800: */
2801: and sysdate between a1.date_from and nvl(a1.date_to, hr_general.end_of_time)

Line 2821: l_addr1 per_addresses.address_line1%type;

2817: l_fu_name per_all_people_f.full_name%type;
2818: l_fi_name per_all_people_f.first_name%type;
2819: l_l_name per_all_people_f.last_name%type;
2820: l_m_names per_all_people_f.middle_names%type;
2821: l_addr1 per_addresses.address_line1%type;
2822: l_addr2 per_addresses.address_line2%type;
2823: l_addr3 per_addresses.address_line3%type;
2824: l_toc per_addresses.town_or_city%type;
2825: l_reg1 per_addresses.region_1%type;

Line 2822: l_addr2 per_addresses.address_line2%type;

2818: l_fi_name per_all_people_f.first_name%type;
2819: l_l_name per_all_people_f.last_name%type;
2820: l_m_names per_all_people_f.middle_names%type;
2821: l_addr1 per_addresses.address_line1%type;
2822: l_addr2 per_addresses.address_line2%type;
2823: l_addr3 per_addresses.address_line3%type;
2824: l_toc per_addresses.town_or_city%type;
2825: l_reg1 per_addresses.region_1%type;
2826: l_reg2 per_addresses.region_2%type;

Line 2823: l_addr3 per_addresses.address_line3%type;

2819: l_l_name per_all_people_f.last_name%type;
2820: l_m_names per_all_people_f.middle_names%type;
2821: l_addr1 per_addresses.address_line1%type;
2822: l_addr2 per_addresses.address_line2%type;
2823: l_addr3 per_addresses.address_line3%type;
2824: l_toc per_addresses.town_or_city%type;
2825: l_reg1 per_addresses.region_1%type;
2826: l_reg2 per_addresses.region_2%type;
2827: l_reg3 per_addresses.region_3%type;

Line 2824: l_toc per_addresses.town_or_city%type;

2820: l_m_names per_all_people_f.middle_names%type;
2821: l_addr1 per_addresses.address_line1%type;
2822: l_addr2 per_addresses.address_line2%type;
2823: l_addr3 per_addresses.address_line3%type;
2824: l_toc per_addresses.town_or_city%type;
2825: l_reg1 per_addresses.region_1%type;
2826: l_reg2 per_addresses.region_2%type;
2827: l_reg3 per_addresses.region_3%type;
2828: l_poc per_addresses.postal_code%type;

Line 2825: l_reg1 per_addresses.region_1%type;

2821: l_addr1 per_addresses.address_line1%type;
2822: l_addr2 per_addresses.address_line2%type;
2823: l_addr3 per_addresses.address_line3%type;
2824: l_toc per_addresses.town_or_city%type;
2825: l_reg1 per_addresses.region_1%type;
2826: l_reg2 per_addresses.region_2%type;
2827: l_reg3 per_addresses.region_3%type;
2828: l_poc per_addresses.postal_code%type;
2829: l_country per_addresses.country%type;

Line 2826: l_reg2 per_addresses.region_2%type;

2822: l_addr2 per_addresses.address_line2%type;
2823: l_addr3 per_addresses.address_line3%type;
2824: l_toc per_addresses.town_or_city%type;
2825: l_reg1 per_addresses.region_1%type;
2826: l_reg2 per_addresses.region_2%type;
2827: l_reg3 per_addresses.region_3%type;
2828: l_poc per_addresses.postal_code%type;
2829: l_country per_addresses.country%type;
2830:

Line 2827: l_reg3 per_addresses.region_3%type;

2823: l_addr3 per_addresses.address_line3%type;
2824: l_toc per_addresses.town_or_city%type;
2825: l_reg1 per_addresses.region_1%type;
2826: l_reg2 per_addresses.region_2%type;
2827: l_reg3 per_addresses.region_3%type;
2828: l_poc per_addresses.postal_code%type;
2829: l_country per_addresses.country%type;
2830:
2831: begin

Line 2828: l_poc per_addresses.postal_code%type;

2824: l_toc per_addresses.town_or_city%type;
2825: l_reg1 per_addresses.region_1%type;
2826: l_reg2 per_addresses.region_2%type;
2827: l_reg3 per_addresses.region_3%type;
2828: l_poc per_addresses.postal_code%type;
2829: l_country per_addresses.country%type;
2830:
2831: begin
2832: open row_person_return;

Line 2829: l_country per_addresses.country%type;

2825: l_reg1 per_addresses.region_1%type;
2826: l_reg2 per_addresses.region_2%type;
2827: l_reg3 per_addresses.region_3%type;
2828: l_poc per_addresses.postal_code%type;
2829: l_country per_addresses.country%type;
2830:
2831: begin
2832: open row_person_return;
2833: fetch row_person_return into l_fu_name,