APPS.MSC_CL_ITEM_ODS_LOAD dependencies on DBA_TAB_STATISTICS

Line 1541: from dba_TAB_STATISTICS

1537:
1538: begin
1539: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1540: into lv_item_id_count, lv_items_stat_stale
1541: from dba_TAB_STATISTICS
1542: where table_name = 'MSC_ITEM_ID_LID';
1543: exception when no_data_found then
1544: lv_items_stat_stale := MSC_UTIL.SYS_YES ;
1545: end;

Line 1550: from dba_TAB_STATISTICS

1546:
1547: begin
1548: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1549: into lv_cat_id_count, lv_cat_stat_stale
1550: from dba_TAB_STATISTICS
1551: where table_name ='MSC_CATEGORY_SET_ID_LID';
1552: exception when no_data_found then
1553: lv_cat_stat_stale := MSC_UTIL.SYS_YES ;
1554: end;