APPS.ZX_MIGRATE_UTIL dependencies on HR_LOCATIONS_ALL

Line 27: l_country hr_locations_all.country%TYPE;

23: +===========================================================================*/
24: FUNCTION GET_TAX_REGIME (p_tax_type IN VARCHAR2,
25: p_org_id IN NUMBER) RETURN VARCHAR2
26: IS
27: l_country hr_locations_all.country%TYPE;
28: p_tax_regime_code VARCHAR2(30);
29:
30: BEGIN
31:

Line 224: l_country hr_locations_all.country%TYPE;

220: +===========================================================================*/
221:
222: FUNCTION get_country(p_org_id IN NUMBER) RETURN VARCHAR2 IS
223:
224: l_country hr_locations_all.country%TYPE;
225: l_style hr_locations_all.style%TYPE;
226: l_vat_country_code financials_system_params_all.vat_country_code%TYPE;
227:
228: BEGIN

Line 225: l_style hr_locations_all.style%TYPE;

221:
222: FUNCTION get_country(p_org_id IN NUMBER) RETURN VARCHAR2 IS
223:
224: l_country hr_locations_all.country%TYPE;
225: l_style hr_locations_all.style%TYPE;
226: l_vat_country_code financials_system_params_all.vat_country_code%TYPE;
227:
228: BEGIN
229: -- 1. Select country code from hr_location

Line 240: hr_locations_all loc

236: INTO l_country,
237: l_style
238: FROM hr_all_organization_units ou,
239: hr_organization_information oi,
240: hr_locations_all loc
241: WHERE ou.organization_id = oi.organization_id
242: AND ou.location_id = loc.location_id
243: AND oi.org_information_context = 'Operating Unit Information'
244: AND oi.organization_id = p_org_id;

Line 252: hr_locations_all loc

248: INTO l_country,
249: l_style
250: FROM hr_all_organization_units ou,
251: hr_organization_information oi,
252: hr_locations_all loc
253: WHERE oi.organization_id = l_org_id
254: AND ou.organization_id = oi.organization_id
255: AND ou.location_id = loc.location_id
256: AND oi.org_information_context = 'Operating Unit Information';