DBA Data[Home] [Help]

APPS.OKI_DBI_UTIL_PVT dependencies on PER_ORGANIZATION_LIST

Line 355: FROM per_organization_list pol

351: THEN
352: l_org_where :=
353: ' AND authoring_org_id IN (
354: SELECT pol.organization_id
355: FROM per_organization_list pol
356: WHERE pol.security_profile_id
357: = &SEC_ID ) ';
358: ELSE
359: l_org_where := ' AND authoring_org_id = &ORGANIZATION+FII_OPERATING_UNITS';

Line 683: FROM per_organization_list

679: FROM financials_system_params_all fsp
680: , gl_sets_of_books gsob
681: WHERE fsp.set_of_books_id = gsob.set_of_books_id
682: AND fsp.org_id IN (SELECT organization_id
683: FROM per_organization_list
684: WHERE security_profile_id = l_sec_profile);
685: END IF;
686:
687: IF ( (p_currency_code = l_common_functional_currency)