APPS.BSC_UPDATE dependencies on BSC_DB_TABLES_COLS

Line 279: FROM bsc_db_tables_cols

275:
276: CURSOR h_cursor (p_table_type NUMBER, p_column_type VARCHAR2, p_indic_type NUMBER,
277: p_config_type NUMBER, p_dim_level_index NUMBER) IS
278: SELECT table_name, column_name
279: FROM bsc_db_tables_cols
280: WHERE table_name IN (
281: SELECT table_name
282: FROM bsc_db_tables_rels
283: WHERE source_table_name IN (

Line 1781: ' FROM bsc_db_tables_cols c, bsc_db_loader_control p'||

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'||
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

Line 1791: FROM bsc_db_tables_cols c, bsc_db_loader_control p

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
1792: WHERE c.table_name = p.input_table_name AND
1793: c.column_type = p_column_type AND p.process_id = p_process_id AND p.status = p_status);
1794:
1795: h_column_type_p VARCHAR2(1);