APPS.POA_CURRENCY_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 193: from financials_system_params_all fsp,

189:
190: if(p_selected_operating_unit <> g_operating_unit or g_operating_unit is null) then
191: select currency_code
192: into g_functional_currency_code
193: from financials_system_params_all fsp,
194: gl_sets_of_books gsob
195: where fsp.org_id = p_selected_operating_unit
196: and fsp.set_of_books_id = gsob.set_of_books_id;
197: g_operating_unit := p_selected_operating_unit;

Line 238: from financials_system_params_all fsp,

234: if(g_common_functional_currency is null or nvl(g_sec_profile_id, -1) <> poa_dbi_util_pkg.get_sec_profile) then
235: g_sec_profile_id := poa_dbi_util_pkg.get_sec_profile;
236: select distinct currency_code
237: into g_common_functional_currency
238: from financials_system_params_all fsp,
239: gl_sets_of_books gsob
240: where fsp.set_of_books_id = gsob.set_of_books_id
241: and fsp.org_id in (select organization_id from per_organization_list where security_profile_id = poa_dbi_util_pkg.get_sec_profile);
242: end if;

Line 249: FROM financials_system_params_all fsp,

245: IF g_common_functional_currency IS NULL THEN
246: IF poa_dbi_util_pkg.get_sec_profile <> -1 THEN
247: SELECT DISTINCT currency_code
248: INTO g_common_functional_currency
249: FROM financials_system_params_all fsp,
250: gl_sets_of_books gsob
251: WHERE fsp.set_of_books_id = gsob.set_of_books_id
252: AND EXISTS (SELECT 1
253: FROM per_organization_list org_list

Line 260: FROM financials_system_params_all fsp,

256:
257: ELSE
258: SELECT DISTINCT currency_code
259: INTO g_common_functional_currency
260: FROM financials_system_params_all fsp,
261: gl_sets_of_books gsob
262: WHERE fsp.set_of_books_id = gsob.set_of_books_id
263: AND fsp.org_id = poa_dbi_util_pkg.get_ou_org_id ;
264: END IF ; --poa_dbi_util_pkg.get_sec_profile <> -1