APPS.PAY_AU_PAYMENT_SUMMARY dependencies on FND_TERRITORIES_TL

Line 2848: l_etp_country fnd_territories_tl.territory_short_name%type;

2844: l_etp_address_3 hr_locations.address_line_3%type;
2845: l_etp_suburb hr_locations.town_or_city%type;
2846: l_etp_state hr_locations.region_1%type;
2847: l_etp_postcode hr_locations.postal_code%type;
2848: l_etp_country fnd_territories_tl.territory_short_name%type;
2849: l_etp_employee_number per_all_people_f.employee_number%type;
2850: l_etp_date_of_birth per_all_people_f.date_of_birth%type;
2851: l_etp_employee_start_date per_periods_of_service.date_start%type;
2852: l_etp_death_benefit per_periods_of_service.leaving_reason%type;

Line 2900: fnd_territories_tl fta,

2896: pay_element_entry_values_f pev,
2897: per_all_assignments_f paa,
2898: per_all_people_f pap,
2899: per_addresses pad,
2900: fnd_territories_tl fta,
2901: per_periods_of_service pps,
2902: pay_payroll_actions ppa,
2903: pay_assignment_actions pac,
2904: hr_locations_all hlc /* Bug No : 2263587 */

Line 2983: l_country fnd_territories_tl.territory_short_name%type;

2979: and pac.tax_unit_id = p_registered_employer
2980: order by prr.run_result_id;
2981:
2982: l_etp_details etp_details%rowtype;
2983: l_country fnd_territories_tl.territory_short_name%type;
2984:
2985: lv_transitional_flag VARCHAR2(1);
2986: lv_part_prev_etp_flag VARCHAR2(1);
2987: Begin

Line 3536: l_country fnd_territories_tl.territory_short_name%type;

3532: l_address_3 hr_locations.address_line_3%type;
3533: l_suburb hr_locations.town_or_city%type;
3534: l_state hr_locations.region_1%type;
3535: l_postcode hr_locations.postal_code%type;
3536: l_country fnd_territories_tl.territory_short_name%type;
3537: l_signatory hr_organization_information.org_information8%type;
3538: e_employer_nf EXCEPTION;
3539:
3540:

Line 3567: ,fnd_territories_tl ftl

3563: ,hlc.postal_code postcode
3564: ,ftl.territory_short_name country
3565: from hr_organization_information hoi
3566: ,hr_locations hlc
3567: ,fnd_territories_tl ftl
3568: ,hr_organization_units hou
3569: ,per_all_people_f papcont
3570: ,per_all_people_f papsign
3571: where hou.business_group_id = p_business_group_id

Line 3757: l_country fnd_territories_tl.territory_short_name%type;

3753: l_address_3 hr_locations.address_line_3%type;
3754: l_suburb hr_locations.town_or_city%type;
3755: l_state hr_locations.region_1%type;
3756: l_postcode hr_locations.postal_code%type;
3757: l_country fnd_territories_tl.territory_short_name%type;
3758: l_start_date VARCHAR2(20);
3759: l_termination_date VARCHAR2(20);
3760: l_dob VARCHAR2(20);
3761: l_asgmnt_loc hr_locations.location_code%type;

Line 3872: fnd_territories_tl fta,

3868: per_all_assignments_f paa,
3869: per_all_assignments_f paaf, /* Bug : 2610141 */
3870: per_all_people_f pap,
3871: per_addresses pad,
3872: fnd_territories_tl fta,
3873: per_periods_of_service pps,
3874: pay_payroll_actions ppa,
3875: pay_assignment_actions pac,
3876: pay_payroll_actions ppa1, /* Bug# 2448441 */

Line 4281: l_supplier_country fnd_territories_tl.territory_short_name%type;

4277: l_supplier_address_3 hr_locations.address_line_3%type;
4278: l_supplier_suburb hr_locations.town_or_city%type;
4279: l_supplier_state hr_locations.region_1%type;
4280: l_supplier_postcode hr_locations.postal_code%type;
4281: l_supplier_country fnd_territories_tl.territory_short_name%type;
4282:
4283: ------------------------------------------------------------------------------+
4284: -- cursor to get supplier details
4285: ------------------------------------------------------------------------------+

Line 4306: ,fnd_territories_tl ftl

4302: ,pap.email_address email_address
4303: from hr_organization_information hoi
4304: ,hr_organization_units hou
4305: ,hr_locations hrl
4306: ,fnd_territories_tl ftl
4307: ,per_all_people_f pap
4308: where hou.business_group_id = p_business_group_id
4309: and hou.organization_id = p_registered_employer
4310: and hou.organization_id = hoi.organization_id