APPS.BIM_FUND_FACTS dependencies on DBMS_STATS

Line 218: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_BALANCE', estimate_percent => 5,

214: null;
215: END;
216:
217: BEGIN
218: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_BALANCE', estimate_percent => 5,
219: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
220: END;
221:
222: --Update the record of mininum date for each fund

Line 2482: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_DAILY_FACTS', estimate_percent => 5,

2478: WHEN OTHERS THEN
2479: null;
2480: END;
2481: BEGIN
2482: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_DAILY_FACTS', estimate_percent => 5,
2483: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2484: END;
2485: BEGIN
2486: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,

Line 2486: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,

2482: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_DAILY_FACTS', estimate_percent => 5,
2483: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2484: END;
2485: BEGIN
2486: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,
2487: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2488: END;
2489: BEGIN
2490: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,

Line 2490: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,

2486: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,
2487: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2488: END;
2489: BEGIN
2490: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,
2491: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2492: END;
2493: BEGIN
2494: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_WEEKLY_FACTS', estimate_percent => 5,

Line 2494: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_WEEKLY_FACTS', estimate_percent => 5,

2490: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,
2491: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2492: END;
2493: BEGIN
2494: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_WEEKLY_FACTS', estimate_percent => 5,
2495: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2496: END;
2497: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
2498: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);

Line 4349: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_DAILY_FACTS', estimate_percent => 5,

4345: END;
4346:
4347: --Analysis tables for better performance
4348: BEGIN
4349: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_DAILY_FACTS', estimate_percent => 5,
4350: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4351: END;
4352: BEGIN
4353: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,

Line 4353: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,

4349: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_DAILY_FACTS', estimate_percent => 5,
4350: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4351: END;
4352: BEGIN
4353: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,
4354: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4355: END;
4356: BEGIN
4357: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,

Line 4357: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,

4353: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,
4354: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4355: END;
4356: BEGIN
4357: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,
4358: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4359: END;
4360: BEGIN
4361: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_WEEKLY_FACTS', estimate_percent => 5,

Line 4361: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_WEEKLY_FACTS', estimate_percent => 5,

4357: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,
4358: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4359: END;
4360: BEGIN
4361: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_WEEKLY_FACTS', estimate_percent => 5,
4362: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4363: END;
4364:
4365: --call update subsequent balance