APPS.BSC_UPDATE dependencies on BSC_SYS_DIM_LEVEL_RELS

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

25: TYPE t_cursor IS REF CURSOR;
26:
27: CURSOR c_parent_tables(p_dim_table VARCHAR2) is
28: SELECT dp.level_table_name
29: FROM bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b dp, bsc_sys_dim_level_rels r
30: WHERE d.dim_level_id = r.dim_level_id AND
31: r.parent_dim_level_id = dp.dim_level_id AND
32: DECODE(r.relation_type, 2, r.relation_col, d.level_table_name) = p_dim_table;
33: