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_CN_PAYSLIP_ARCHIVE dependencies on FND_TERRITORIES_TL

Line 1463: ,fnd_territories_tl ft

1459: ,hl.postal_code
1460: ,hl.telephone_number_1
1461: FROM hr_all_organization_units hou
1462: ,hr_locations hl
1463: ,fnd_territories_tl ft
1464: WHERE hou.organization_id = p_employer_id
1465: AND hou.location_id = hl.location_id
1466: AND hl.country = ft.territory_code
1467: AND ft.language = userenv ('LANG');

Line 1481: l_country fnd_territories_tl.territory_short_name%TYPE;

1477: l_dummy VARCHAR2(10);
1478: l_address_line_1 hr_locations.address_line_1%TYPE;
1479: l_address_line_2 hr_locations.address_line_2%TYPE;
1480: l_province hr_lookups.meaning%TYPE;
1481: l_country fnd_territories_tl.territory_short_name%TYPE;
1482: l_postal_code hr_locations.postal_code%TYPE;
1483: l_telephone_no hr_locations.telephone_number_1%TYPE;
1484: l_file_number hr_organization_information.org_information8%TYPE;
1485: l_procedure VARCHAR2(80);