APPS.BSC_UPDATE_DIM dependencies on BSC_SYS_DIM_LEVEL_COLS

Line 1646: ' FROM bsc_sys_dim_level_cols c, bsc_sys_dim_levels_b d'||

1642:
1643: /*
1644: c_aux_fields t_cursor; -- x_dim_table, h_column_type_a
1645: c_aux_fields_sql VARCHAR2(2000) := 'SELECT c.column_name'||
1646: ' FROM bsc_sys_dim_level_cols c, bsc_sys_dim_levels_b d'||
1647: ' WHERE d.dim_level_id = c.dim_level_id AND'||
1648: ' d.level_table_name = :1 AND'||
1649: ' column_type = :2';
1650: */

Line 1653: FROM bsc_sys_dim_level_cols c, bsc_sys_dim_levels_b d

1649: ' column_type = :2';
1650: */
1651: CURSOR c_aux_fields (p_level_table_name VARCHAR2, p_column_type VARCHAR2) IS
1652: SELECT c.column_name
1653: FROM bsc_sys_dim_level_cols c, bsc_sys_dim_levels_b d
1654: WHERE d.dim_level_id = c.dim_level_id AND
1655: d.level_table_name = p_level_table_name AND
1656: column_type = p_column_type;
1657:

Line 1660: h_aux_field bsc_sys_dim_level_cols.column_name%TYPE;

1656: column_type = p_column_type;
1657:
1658: h_column_type_a VARCHAR2(1);
1659:
1660: h_aux_field bsc_sys_dim_level_cols.column_name%TYPE;
1661: h_num_aux_fields NUMBER;
1662:
1663: BEGIN
1664: h_column_type_a := 'A';