APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on FND_TERRITORIES_TL

Line 1591: ,fnd_territories_tl ft

1587: ,hl.postal_code
1588: ,hl.telephone_number_1
1589: FROM hr_all_organization_units hou
1590: ,hr_locations hl
1591: ,fnd_territories_tl ft
1592: WHERE hou.organization_id = p_employer_id
1593: AND hou.location_id = hl.location_id
1594: AND hl.country = ft.territory_code
1595: AND ft.language = userenv ('LANG');

Line 1609: l_country fnd_territories_tl.territory_short_name%TYPE;

1605: l_dummy VARCHAR2(10);
1606: l_address_line_1 hr_locations.address_line_1%TYPE;
1607: l_address_line_2 hr_locations.address_line_2%TYPE;
1608: l_province hr_lookups.meaning%TYPE;
1609: l_country fnd_territories_tl.territory_short_name%TYPE;
1610: l_postal_code hr_locations.postal_code%TYPE;
1611: l_telephone_no hr_locations.telephone_number_1%TYPE;
1612: l_file_number hr_organization_information.org_information8%TYPE;
1613: l_procedure VARCHAR2(80);