APPS.BSC_BSC_ADAPTER dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 3171: bsc_sys_dim_level_rels rel

3167: rel.relation_col
3168: from
3169: bsc_sys_dim_levels_b lvl,
3170: bsc_sys_dim_levels_b par_lvl,
3171: bsc_sys_dim_level_rels rel
3172: where
3173: lvl.level_table_name=p_level
3174: and lvl.dim_level_id=rel.dim_level_id
3175: and rel.relation_type=1

Line 3181: 'bsc_sys_dim_levels_b par_lvl,bsc_sys_dim_level_rels rel where lvl.level_table_name='''||p_child_level||''''||

3177: -------------
3178: Begin
3179: if g_debug then
3180: write_to_log_file_n('select par_lvl.level_table_name,rel.relation_col from bsc_sys_dim_levels_b lvl,'||
3181: 'bsc_sys_dim_levels_b par_lvl,bsc_sys_dim_level_rels rel where lvl.level_table_name='''||p_child_level||''''||
3182: 'and lvl.dim_level_id=rel.dim_level_id and rel.relation_type=1 and par_lvl.dim_level_id=rel.parent_dim_level_id');
3183: end if;
3184: p_num_parent_levels:=1;
3185: open c1(p_child_level);