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 1967: ,fnd_territories_vl ft

1963: ,pap.effective_end_date
1964: ,pap.EMPLOYEE_NUMBER
1965: ,pap.date_of_birth -- EOY 2008/2009
1966: FROM per_all_people_f pap
1967: ,fnd_territories_vl ft
1968: WHERE pap.person_id = csr_v_person_id
1969: AND pap.per_information_category = 'SE'
1970: AND ft.obsolete_flag = 'N'
1971: AND ft.territory_code = pap.per_information1

Line 1998: ,fnd_territories_vl ft

1994: ,postal_code
1995: ,country
1996: ,ft.territory_short_name
1997: FROM per_addresses
1998: ,fnd_territories_vl ft
1999: WHERE business_group_id = g_business_group_id
2000: AND person_id = csr_v_person_id
2001: AND country = ft.territory_code
2002: AND csr_v_effective_date BETWEEN date_from

Line 5404: FROM fnd_territories_vl ft

5400: IS
5401: CURSOR csr_get_country_details
5402: IS
5403: SELECT ft.territory_short_name
5404: FROM fnd_territories_vl ft
5405: WHERE ft.territory_code = p_code;
5406:
5407: lr_get_country_details csr_get_country_details%ROWTYPE;
5408: