APPS.BSC_UPDATE dependencies on BSC_SYS_DIM_LEVELS_B

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:

Line 34: h_parent_table bsc_sys_dim_levels_b.level_table_name%TYPE;

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:
34: h_parent_table bsc_sys_dim_levels_b.level_table_name%TYPE;
35: h_ret BOOLEAN;
36:
37: BEGIN
38: h_ret := TRUE;

Line 1778: ' FROM bsc_sys_dim_levels_b'||

1774:
1775: /*
1776: c_edw_dimensions t_cursor; -- 1, h_column_type_p, g_process_id, LC_PENDING_STATUS
1777: c_edw_dimensions_sql VARCHAR2(2000) := 'SELECT level_table_name'||
1778: ' FROM bsc_sys_dim_levels_b'||
1779: ' WHERE NVL(edw_flag, 0) = :1 AND'||
1780: ' level_pk_col IN (SELECT column_name'||
1781: ' FROM bsc_db_tables_cols c, bsc_db_loader_control p'||
1782: ' WHERE c.table_name = p.input_table_name AND'||

Line 1787: FROM bsc_sys_dim_levels_b

1783: ' c.column_type = :2 AND p.process_id = :3 AND p.status = :4)';
1784: */
1785: CURSOR c_edw_dimensions (p_edw_flag NUMBER, p_column_type VARCHAR2, p_process_id NUMBER, p_status VARCHAR2) IS
1786: SELECT level_table_name
1787: FROM bsc_sys_dim_levels_b
1788: WHERE NVL(edw_flag, 0) = p_edw_flag AND
1789: level_pk_col IN (
1790: SELECT column_name
1791: FROM bsc_db_tables_cols c, bsc_db_loader_control p