APPS.FII_TIME_C dependencies on FII_TIME_CAL_DAY_MV

Line 2975: ----- dbms_mview.REFRESH('FII_TIME_CAL_DAY_MV','C');

2971: commit;
2972:
2973: ------------------------------------------------------------------------------
2974: --Bug 3155474: call BIS wrapper to handle force parallel on MVs
2975: ----- dbms_mview.REFRESH('FII_TIME_CAL_DAY_MV','C');
2976:
2977: BIS_MV_REFRESH.refresh_wrapper ('FII_TIME_CAL_DAY_MV', 'C');
2978: ------------------------------------------------------------------------------
2979:

Line 2977: BIS_MV_REFRESH.refresh_wrapper ('FII_TIME_CAL_DAY_MV', 'C');

2973: ------------------------------------------------------------------------------
2974: --Bug 3155474: call BIS wrapper to handle force parallel on MVs
2975: ----- dbms_mview.REFRESH('FII_TIME_CAL_DAY_MV','C');
2976:
2977: BIS_MV_REFRESH.refresh_wrapper ('FII_TIME_CAL_DAY_MV', 'C');
2978: ------------------------------------------------------------------------------
2979:
2980: if g_debug_flag = 'Y' then
2981: fii_util.stop_timer;

Line 3800: FROM fii_time_cal_day_mv

3796: , report_date
3797: , cal_period_start_date period_start_date
3798: , cal_qtr_start_date qtr_start_date
3799: , cal_year_start_date year_start_date
3800: FROM fii_time_cal_day_mv
3801: WHERE calendar_id = cur_Fiscal_Calendar.calendar_id
3802: AND report_date BETWEEN l_from_date AND l_to_date) LOOP
3803:
3804: INSERT INTO FII_TIME_CAL_RPT_STRUCT

Line 3976: FROM FII_TIME_CAL_DAY_MV

3972: , SYSDATE
3973: , g_user_id
3974: , g_user_id
3975: , g_login_id
3976: FROM FII_TIME_CAL_DAY_MV
3977: WHERE calendar_id = cur_Fiscal_Days.calendar_id
3978: AND report_date BETWEEN cur_Fiscal_Days.period_start_date AND l_Day;
3979:
3980: l_Row := l_Row + SQL%ROWCOUNT;