DBA Data[Home] [Help]

APPS.POA_CURRENCY_PKG dependencies on PER_ORGANIZATION_LIST

Line 241: and fsp.org_id in (select organization_id from per_organization_list where security_profile_id = poa_dbi_util_pkg.get_sec_profile);

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: */
244:
245: IF g_common_functional_currency IS NULL THEN

Line 253: FROM per_organization_list org_list

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
255: AND org_list.organization_id = fsp.org_id );
256:
257: ELSE