APPS.BSC_UPDATE_BASE dependencies on ALL_TABLES

Line 2834: from all_tables

2830: -- Fix bug#3875046: Replace the insert stmt with following logic
2831: -- a. get number of rows of the base table. Since the base table is analyzed we can do:
2832: select nvl(num_rows,0)
2833: into h_num_rows_base
2834: from all_tables
2835: where table_name = x_base_tbl and owner= BSC_APPS.BSC_APPS_SCHEMA;
2836: --b. see what hint to use
2837: -- Fix bug#4097873: remove ordered hint
2838: if h_num_rows_base = 0 then