DBA Data[Home] [Help]

APPS.BSC_UPDATE_UTIL dependencies on ALL_TABLES

Line 4794: ' FROM ALL_TABLES'||

4790:
4791: /*
4792: get_table_apps t_cursor; -- X_Table, BSC_APPS.BSC_APPS_SCHEMA
4793: get_table_apps_sql VARCHAR2(2000) := 'SELECT table_name'||
4794: ' FROM ALL_TABLES'||
4795: ' WHERE table_name = :1'||
4796: ' AND owner = :2';
4797: */
4798: CURSOR get_table_apps (p_table_name VARCHAR2, p_owner VARCHAR2) IS

Line 4800: FROM ALL_TABLES

4796: ' AND owner = :2';
4797: */
4798: CURSOR get_table_apps (p_table_name VARCHAR2, p_owner VARCHAR2) IS
4799: SELECT table_name
4800: FROM ALL_TABLES
4801: WHERE table_name = p_table_name AND owner = p_owner;
4802:
4803: h_tbl VARCHAR2(30);
4804: h_table VARCHAR2(30);