APPS.POA_CURRENCY_PKG dependencies on GL_SETS_OF_BOOKS

Line 194: gl_sets_of_books gsob

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;
198: end if;

Line 239: gl_sets_of_books gsob

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;
243: */

Line 250: gl_sets_of_books gsob

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
254: WHERE org_list.security_profile_id = poa_dbi_util_pkg.get_sec_profile

Line 261: gl_sets_of_books gsob

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
265: END IF ; --g_functional_currency IS NULL