APPS.BSC_UPDATE_DIM dependencies on BSC_DB_TABLES_RELS

Line 743: FROM bsc_db_tables_rels

739: CURSOR c_system_tables (p_col_name1 VARCHAR2, p_col_name2 VARCHAR2,
740: p_col_type VARCHAR2, p_table_type NUMBER, p_count NUMBER) IS
741: SELECT DISTINCT bt.table_name
742: FROM (SELECT DISTINCT table_name
743: FROM bsc_db_tables_rels
744: WHERE source_table_name IN (
745: SELECT table_name
746: FROM bsc_db_tables
747: WHERE table_type = p_table_type)

Line 836: FROM bsc_db_tables_rels

832: -- BSC-MV Note: Change query to get only base tables. This logic is valid for both architectures
833: CURSOR c_affected_tables (p_col_name VARCHAR2, p_col_type VARCHAR2, p_table_type NUMBER) IS
834: SELECT DISTINCT bt.table_name
835: FROM (SELECT DISTINCT table_name
836: FROM bsc_db_tables_rels
837: WHERE source_table_name IN (
838: SELECT table_name
839: FROM bsc_db_tables
840: WHERE table_type = p_table_type)

Line 1964: ' FROM bsc_db_tables_rels'||

1960:
1961: BEGIN
1962: /*
1963: h_sql := 'SELECT table_name'||
1964: ' FROM bsc_db_tables_rels'||
1965: ' WHERE source_table_name = :1';
1966: OPEN h_cursor FOR h_sql USING x_input_table;
1967: FETCH h_cursor INTO h_table_name;
1968: CLOSE h_cursor;

Line 1972: FROM bsc_db_tables_rels

1968: CLOSE h_cursor;
1969: */
1970: SELECT table_name
1971: INTO h_table_name
1972: FROM bsc_db_tables_rels
1973: WHERE source_table_name = x_input_table;
1974:
1975: RETURN h_table_name;
1976: