APPS.PAY_IE_PAY_ADVICE_REPORT dependencies on FND_TERRITORIES_VL

Line 132: FND_TERRITORIES_VL fnd_ter

128: begin
129: hr_utility.trace('Entering ' ||g_package || 'get_country' );
130: select TERRITORY_SHORT_NAME into l_country
131: from hr_locations_all,
132: FND_TERRITORIES_VL fnd_ter
133: where location_code = p_location_code and
134: nvl(BUSINESS_GROUP_ID,p_business_group_id) =
135: p_business_group_id and
136: FND_TER.TERRITORY_CODE(+) = COUNTRY;