DBA Data[Home] [Help]

APPS.ZX_MIGRATE_UTIL dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 226: l_vat_country_code financials_system_params_all.vat_country_code%TYPE;

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

Line 287: FROM financials_system_params_all

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