APPS.PAY_AU_PAYMENT_SUMMARY dependencies on FND_TERRITORIES_TL

Line 5126: l_etp_country fnd_territories_tl.territory_short_name%type;

5122: l_etp_address_3 hr_locations.address_line_3%type;
5123: l_etp_suburb hr_locations.town_or_city%type;
5124: l_etp_state hr_locations.region_1%type;
5125: l_etp_postcode hr_locations.postal_code%type;
5126: l_etp_country fnd_territories_tl.territory_short_name%type;
5127: l_etp_employee_number per_all_people_f.employee_number%type;
5128: l_etp_date_of_birth per_all_people_f.date_of_birth%type;
5129: l_etp_employee_start_date per_periods_of_service.date_start%type;
5130: l_etp_death_benefit per_periods_of_service.leaving_reason%type;

Line 5180: fnd_territories_tl fta,

5176: pay_element_entry_values_f pev,
5177: per_all_assignments_f paa,
5178: per_all_people_f pap,
5179: per_addresses pad,
5180: fnd_territories_tl fta,
5181: per_periods_of_service pps,
5182: pay_payroll_actions ppa,
5183: pay_assignment_actions pac,
5184: hr_locations_all hlc /* Bug No : 2263587 */

Line 5264: l_country fnd_territories_tl.territory_short_name%type;

5260: and pac.tax_unit_id = p_registered_employer
5261: order by prr.run_result_id;
5262:
5263: l_etp_details etp_details%rowtype;
5264: l_country fnd_territories_tl.territory_short_name%type;
5265:
5266: lv_transitional_flag VARCHAR2(1);
5267: lv_part_prev_etp_flag VARCHAR2(1);
5268: Begin

Line 6979: l_country fnd_territories_tl.territory_short_name%type;

6975: l_address_3 hr_locations.address_line_3%type;
6976: l_suburb hr_locations.town_or_city%type;
6977: l_state hr_locations.region_1%type;
6978: l_postcode hr_locations.postal_code%type;
6979: l_country fnd_territories_tl.territory_short_name%type;
6980: l_signatory hr_organization_information.org_information8%type;
6981: e_employer_nf EXCEPTION;
6982:
6983:

Line 7010: ,fnd_territories_tl ftl

7006: ,hlc.postal_code postcode
7007: ,ftl.territory_short_name country
7008: from hr_organization_information hoi
7009: ,hr_locations hlc
7010: ,fnd_territories_tl ftl
7011: ,hr_organization_units hou
7012: ,per_all_people_f papcont
7013: ,per_all_people_f papsign
7014: where hou.business_group_id = p_business_group_id

Line 7200: l_country fnd_territories_tl.territory_short_name%type;

7196: l_address_3 hr_locations.address_line_3%type;
7197: l_suburb hr_locations.town_or_city%type;
7198: l_state hr_locations.region_1%type;
7199: l_postcode hr_locations.postal_code%type;
7200: l_country fnd_territories_tl.territory_short_name%type;
7201: l_start_date VARCHAR2(20);
7202: l_termination_date VARCHAR2(20);
7203: l_dob VARCHAR2(20);
7204: l_asgmnt_loc hr_locations.location_code%type;

Line 7317: fnd_territories_tl fta,

7313: per_all_assignments_f paa,
7314: per_all_assignments_f paaf, /* Bug : 2610141 */
7315: per_all_people_f pap,
7316: per_addresses pad,
7317: fnd_territories_tl fta,
7318: per_periods_of_service pps,
7319: pay_payroll_actions ppa,
7320: pay_assignment_actions pac,
7321: pay_payroll_actions ppa1, /* Bug# 2448441 */

Line 7743: l_supplier_country fnd_territories_tl.territory_short_name%type;

7739: l_supplier_address_3 hr_locations.address_line_3%type;
7740: l_supplier_suburb hr_locations.town_or_city%type;
7741: l_supplier_state hr_locations.region_1%type;
7742: l_supplier_postcode hr_locations.postal_code%type;
7743: l_supplier_country fnd_territories_tl.territory_short_name%type;
7744:
7745: ------------------------------------------------------------------------------+
7746: -- cursor to get supplier details
7747: ------------------------------------------------------------------------------+

Line 7768: ,fnd_territories_tl ftl

7764: ,pap.email_address email_address
7765: from hr_organization_information hoi
7766: ,hr_organization_units hou
7767: ,hr_locations hrl
7768: ,fnd_territories_tl ftl
7769: ,per_all_people_f pap
7770: where hou.business_group_id = p_business_group_id
7771: and hou.organization_id = p_registered_employer
7772: and hou.organization_id = hoi.organization_id