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 222: l_country hr_locations_all.country%TYPE;

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

Line 223: l_style hr_locations_all.style%TYPE;

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

Line 238: hr_locations_all loc

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

Line 250: hr_locations_all loc

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