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_SE_INCOME_STATEMENT dependencies on FND_TERRITORIES_VL

Line 406: ,fnd_territories_vl ft

402: ,hl.region_2
403: ,ft.territory_short_name
404: FROM hr_organization_units hou
405: ,hr_locations hl
406: ,fnd_territories_vl ft
407: WHERE hl.location_id = csr_v_location_id
408: AND hl.country = ft.territory_code;
409:
410: lr_address_details csr_address_details%ROWTYPE;

Line 1952: ,fnd_territories_vl ft

1948: ,ft.territory_code
1949: ,pap.effective_end_date
1950: ,pap.EMPLOYEE_NUMBER
1951: FROM per_all_people_f pap
1952: ,fnd_territories_vl ft
1953: WHERE pap.person_id = csr_v_person_id
1954: AND pap.per_information_category = 'SE'
1955: AND ft.obsolete_flag = 'N'
1956: AND ft.territory_code = pap.per_information1

Line 1983: ,fnd_territories_vl ft

1979: ,postal_code
1980: ,country
1981: ,ft.territory_short_name
1982: FROM per_addresses
1983: ,fnd_territories_vl ft
1984: WHERE business_group_id = g_business_group_id
1985: AND person_id = csr_v_person_id
1986: AND country = ft.territory_code
1987: AND csr_v_effective_date BETWEEN date_from

Line 5153: FROM fnd_territories_vl ft

5149: IS
5150: CURSOR csr_get_country_details
5151: IS
5152: SELECT ft.territory_short_name
5153: FROM fnd_territories_vl ft
5154: WHERE ft.territory_code = p_code;
5155:
5156: lr_get_country_details csr_get_country_details%ROWTYPE;
5157: