APPS.MSC_CL_SETUP_ODS_LOAD dependencies on DBA_TAB_STATISTICS

Line 4007: from dba_TAB_STATISTICS

4003:
4004: begin
4005: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
4006: into lv_tp_id_count, lv_tp_stat_stale
4007: from dba_TAB_STATISTICS
4008: where table_name = 'MSC_TP_ID_LID';
4009: exception when no_data_found then
4010: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4011: end;

Line 4016: from dba_TAB_STATISTICS

4012:
4013: begin
4014: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
4015: into lv_tp_site_id_count, lv_tp_site_stat_stale
4016: from dba_TAB_STATISTICS
4017: where table_name ='MSC_TP_SITE_ID_LID';
4018: exception when no_data_found then
4019: lv_tp_site_stat_stale := MSC_UTIL.SYS_YES ;
4020: end;