APPS.BSC_UPDATE_LOCK dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 765: FROM bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b dp, bsc_sys_dim_level_rels r

761: h_dim_level_id NUMBER;
762:
763: CURSOR c_parent_dims IS
764: SELECT dp.dim_level_id
765: FROM bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b dp, bsc_sys_dim_level_rels r
766: WHERE d.dim_level_id = r.dim_level_id AND
767: r.parent_dim_level_id = dp.dim_level_id AND
768: DECODE(r.relation_type, 2, r.relation_col, d.level_table_name) = x_dim_table;
769:

Line 776: from bsc_sys_dim_level_rels

772: CURSOR c_child_dims (p_dim_level_id NUMBER) IS
773: select distinct dim_level_id
774: from
775: (select dim_level_id, parent_dim_level_id
776: from bsc_sys_dim_level_rels
777: where relation_type = 1
778: )
779: start with parent_dim_level_id = p_dim_level_id
780: connect by parent_dim_level_id = prior dim_level_id;