APPS.BSC_UPDATE_INC dependencies on BSC_DB_TABLES_RELS

Line 46: h_sql := h_sql||' FROM bsc_db_tables_rels';

42:
43: FOR h_i IN 1 .. x_num_tables LOOP
44: -- Insert the child tables
45: h_sql := 'SELECT table_name';
46: h_sql := h_sql||' FROM bsc_db_tables_rels';
47: h_sql := h_sql||' WHERE source_table_name = :1';
48:
49: OPEN h_cursor FOR h_sql USING x_tables(h_i);
50: FETCH h_cursor INTO h_table_name;

Line 68: h_sql := h_sql||' FROM bsc_db_tables_rels';

64: CLOSE h_cursor;
65:
66: -- Insert the parent tables
67: h_sql := 'SELECT source_table_name';
68: h_sql := h_sql||' FROM bsc_db_tables_rels';
69: h_sql := h_sql||' WHERE table_name = :1';
70:
71: OPEN h_cursor FOR h_sql USING x_tables(h_i);
72: FETCH h_cursor INTO h_table_name;

Line 545: FROM bsc_db_tables_rels

541: TYPE t_cursor IS REF CURSOR;
542:
543: cursor c_source_tables(pTableName varchar2) is
544: SELECT source_table_name
545: FROM bsc_db_tables_rels
546: WHERE table_name = pTableName ;
547:
548: h_source_table VARCHAR2(30);
549:

Line 1116: ' FROM bsc_db_tables_rels r, bsc_db_tables t'||

1112: -- and also we need to tuncate the kpi cubes.
1113: IF BSC_APPS.bsc_mv THEN
1114: -- Get the base tables
1115: h_sql := 'SELECT r.table_name'||
1116: ' FROM bsc_db_tables_rels r, bsc_db_tables t'||
1117: ' WHERE r.source_table_name = t.table_name AND'||
1118: ' t.table_type = :1 AND ('||h_where_tables_mv||')';
1119: OPEN h_cursor FOR h_sql USING 0;
1120: LOOP