APPS.HR_LOCATIONS_PKG dependencies on FND_TERRITORIES_VL

Line 148: FROM FND_TERRITORIES_VL FT,

144: where application_id = p_resp_appl_id;
145: --
146: cursor c5 is
147: SELECT FT.TERRITORY_SHORT_NAME,FT.TERRITORY_CODE
148: FROM FND_TERRITORIES_VL FT,
149: FND_DESCR_FLEX_CONTEXTS FDFC
150: WHERE FT.TERRITORY_CODE = p_legislation_code
151: AND substr(FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE,1,2) = FT.TERRITORY_CODE
152: AND FDFC.DESCRIPTIVE_FLEXFIELD_NAME = 'Address Location'