APPS.BSC_DBGEN_METADATA_READER dependencies on BSC_SYS_DIM_LEVELS_B
Line 263: and dim_level_id in (select dim_level_id from bsc_sys_dim_levels_b where level_table_name=p_dim_level);
259: l_count number;
260: cursor cRec is
261: select count(1) from bsc_sys_dim_level_rels
262: where dim_level_id=parent_dim_level_id 263: and dim_level_id in (select dim_level_id from bsc_sys_dim_levels_b where level_table_name=p_dim_level); 264: BEGIN
265: bsc_olap_main.get_list_of_rec_dim(gRecDims, l_num_dim_list, l_error);
266: FOR i IN gRecDims.first..gRecDims.last LOOP
267: IF (p_dim_level = gRecDims(i)) THEN