DBA Data[Home] [Help]

APPS.ZX_MIGRATE_UTIL dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 224: l_vat_country_code financials_system_params_all.vat_country_code%TYPE;

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
228: BEGIN

Line 285: FROM financials_system_params_all

281: IF l_country IS NULL THEN
282: BEGIN
283: SELECT vat_country_code
284: INTO l_vat_country_code
285: FROM financials_system_params_all
286: WHERE decode(l_multi_org_flag,'N',l_org_id,org_id) = p_org_id;
287: EXCEPTION
288: WHEN OTHERS THEN
289: l_country := NULL;