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 2724: per_addresses a1,

2720: a1.region_3,
2721: a1.postal_code,
2722: a1.country
2723: from pay_action_information a,
2724: per_addresses a1,
2725: per_all_assignments_f per
2726: where per.assignment_id = p_assignment_id
2727: and p_asg_end_date between per.effective_start_date and per.effective_end_date
2728: and a1.person_id = per.person_id

Line 2731: from per_addresses a2

2727: and p_asg_end_date between per.effective_start_date and per.effective_end_date
2728: and a1.person_id = per.person_id
2729: /*
2730: and a1.date_from = (select max(a2.date_from)
2731: from per_addresses a2
2732: where a2.primary_flag = 'Y'
2733: and a2.person_id = a1.person_id)
2734: */
2735: and sysdate between a1.date_from and nvl(a1.date_to, hr_general.end_of_time)

Line 2755: l_addr1 per_addresses.address_line1%type;

2751: l_fu_name per_all_people_f.full_name%type;
2752: l_fi_name per_all_people_f.first_name%type;
2753: l_l_name per_all_people_f.last_name%type;
2754: l_m_names per_all_people_f.middle_names%type;
2755: l_addr1 per_addresses.address_line1%type;
2756: l_addr2 per_addresses.address_line2%type;
2757: l_addr3 per_addresses.address_line3%type;
2758: l_toc per_addresses.town_or_city%type;
2759: l_reg1 per_addresses.region_1%type;

Line 2756: l_addr2 per_addresses.address_line2%type;

2752: l_fi_name per_all_people_f.first_name%type;
2753: l_l_name per_all_people_f.last_name%type;
2754: l_m_names per_all_people_f.middle_names%type;
2755: l_addr1 per_addresses.address_line1%type;
2756: l_addr2 per_addresses.address_line2%type;
2757: l_addr3 per_addresses.address_line3%type;
2758: l_toc per_addresses.town_or_city%type;
2759: l_reg1 per_addresses.region_1%type;
2760: l_reg2 per_addresses.region_2%type;

Line 2757: l_addr3 per_addresses.address_line3%type;

2753: l_l_name per_all_people_f.last_name%type;
2754: l_m_names per_all_people_f.middle_names%type;
2755: l_addr1 per_addresses.address_line1%type;
2756: l_addr2 per_addresses.address_line2%type;
2757: l_addr3 per_addresses.address_line3%type;
2758: l_toc per_addresses.town_or_city%type;
2759: l_reg1 per_addresses.region_1%type;
2760: l_reg2 per_addresses.region_2%type;
2761: l_reg3 per_addresses.region_3%type;

Line 2758: l_toc per_addresses.town_or_city%type;

2754: l_m_names per_all_people_f.middle_names%type;
2755: l_addr1 per_addresses.address_line1%type;
2756: l_addr2 per_addresses.address_line2%type;
2757: l_addr3 per_addresses.address_line3%type;
2758: l_toc per_addresses.town_or_city%type;
2759: l_reg1 per_addresses.region_1%type;
2760: l_reg2 per_addresses.region_2%type;
2761: l_reg3 per_addresses.region_3%type;
2762: l_poc per_addresses.postal_code%type;

Line 2759: l_reg1 per_addresses.region_1%type;

2755: l_addr1 per_addresses.address_line1%type;
2756: l_addr2 per_addresses.address_line2%type;
2757: l_addr3 per_addresses.address_line3%type;
2758: l_toc per_addresses.town_or_city%type;
2759: l_reg1 per_addresses.region_1%type;
2760: l_reg2 per_addresses.region_2%type;
2761: l_reg3 per_addresses.region_3%type;
2762: l_poc per_addresses.postal_code%type;
2763: l_country per_addresses.country%type;

Line 2760: l_reg2 per_addresses.region_2%type;

2756: l_addr2 per_addresses.address_line2%type;
2757: l_addr3 per_addresses.address_line3%type;
2758: l_toc per_addresses.town_or_city%type;
2759: l_reg1 per_addresses.region_1%type;
2760: l_reg2 per_addresses.region_2%type;
2761: l_reg3 per_addresses.region_3%type;
2762: l_poc per_addresses.postal_code%type;
2763: l_country per_addresses.country%type;
2764:

Line 2761: l_reg3 per_addresses.region_3%type;

2757: l_addr3 per_addresses.address_line3%type;
2758: l_toc per_addresses.town_or_city%type;
2759: l_reg1 per_addresses.region_1%type;
2760: l_reg2 per_addresses.region_2%type;
2761: l_reg3 per_addresses.region_3%type;
2762: l_poc per_addresses.postal_code%type;
2763: l_country per_addresses.country%type;
2764:
2765: begin

Line 2762: l_poc per_addresses.postal_code%type;

2758: l_toc per_addresses.town_or_city%type;
2759: l_reg1 per_addresses.region_1%type;
2760: l_reg2 per_addresses.region_2%type;
2761: l_reg3 per_addresses.region_3%type;
2762: l_poc per_addresses.postal_code%type;
2763: l_country per_addresses.country%type;
2764:
2765: begin
2766: open row_person_return;

Line 2763: l_country per_addresses.country%type;

2759: l_reg1 per_addresses.region_1%type;
2760: l_reg2 per_addresses.region_2%type;
2761: l_reg3 per_addresses.region_3%type;
2762: l_poc per_addresses.postal_code%type;
2763: l_country per_addresses.country%type;
2764:
2765: begin
2766: open row_person_return;
2767: fetch row_person_return into l_fu_name,