APPS.BSC_UPDATE_SUM dependencies on BSC_DB_TABLES_RELS

Line 2234: ' FROM bsc_db_tables_rels'||

2230:
2231: /*
2232: c_origin_tables t_cursor; -- x_table_name, 0
2233: c_origin_tables_sql VARCHAR2(2000) := 'SELECT source_table_name'||
2234: ' FROM bsc_db_tables_rels'||
2235: ' WHERE table_name = :1 AND relation_type = :2';
2236: */
2237: CURSOR c_origin_tables (p_table_name VARCHAR2, p_relation_type NUMBER) IS
2238: SELECT source_table_name

Line 2239: FROM bsc_db_tables_rels

2235: ' WHERE table_name = :1 AND relation_type = :2';
2236: */
2237: CURSOR c_origin_tables (p_table_name VARCHAR2, p_relation_type NUMBER) IS
2238: SELECT source_table_name
2239: FROM bsc_db_tables_rels
2240: WHERE table_name = p_table_name AND relation_type = p_relation_type;
2241:
2242: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;
2243:

Line 2242: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;

2238: SELECT source_table_name
2239: FROM bsc_db_tables_rels
2240: WHERE table_name = p_table_name AND relation_type = p_relation_type;
2241:
2242: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;
2243:
2244: BEGIN
2245: --OPEN c_origin_tables FOR c_origin_tables_sql USING x_table_name, 0;
2246: OPEN c_origin_tables(x_table_name, 0);