DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_LOOKUPS_V

Line 407: FROM IEX_LOOKUPS_V

403: and org_id is null;
404:
405: CURSOR c_allowed_levels IS
406: SELECT LOOKUP_CODE
407: FROM IEX_LOOKUPS_V
408: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
409: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
410:
411: cursor c_get_ou_biz_lvl(c_org_id number) is

Line 735: FROM IEX_LOOKUPS_V

731: and org_id is null;
732:
733: CURSOR c_allowed_levels IS
734: SELECT LOOKUP_CODE
735: FROM IEX_LOOKUPS_V
736: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
737: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
738:
739: cursor c_get_ou_biz_lvl(c_org_id number) is

Line 13518: FROM IEX_LOOKUPS_V

13514: order by nvl(org_id,0) desc ;
13515:
13516: CURSOR c_allowed_levels IS
13517: SELECT LOOKUP_CODE
13518: FROM IEX_LOOKUPS_V
13519: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
13520: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
13521:
13522: CURSOR c_org(c_org_id number) IS