APPS.FII_TIME_C dependencies on FII_TIME_MONTH

Line 769: select min(start_date) into l_min_date from fii_time_month;

765: --Used a decode for the same
766: l_min_date := p_from_date;
767: ELSE
768: -- Incremental run
769: select min(start_date) into l_min_date from fii_time_month;
770: END IF;
771:
772: -- Bug 5624487
773: -- delete from FII_TIME_MONTH where start_date <= l_to_date and end_date >= l_from_date;

Line 773: -- delete from FII_TIME_MONTH where start_date <= l_to_date and end_date >= l_from_date;

769: select min(start_date) into l_min_date from fii_time_month;
770: END IF;
771:
772: -- Bug 5624487
773: -- delete from FII_TIME_MONTH where start_date <= l_to_date and end_date >= l_from_date;
774: delete from FII_TIME_MONTH
775: where start_date <= l_to_date and end_date >= l_from_date
776: or end_date >= g_unassigned_day;
777:

Line 774: delete from FII_TIME_MONTH

770: END IF;
771:
772: -- Bug 5624487
773: -- delete from FII_TIME_MONTH where start_date <= l_to_date and end_date >= l_from_date;
774: delete from FII_TIME_MONTH
775: where start_date <= l_to_date and end_date >= l_from_date
776: or end_date >= g_unassigned_day;
777:
778: -- ----------------------

Line 791: insert into fii_time_month

787: end if;
788: while l_month <= l_to_date or l_month_end = g_unassigned_day loop
789:
790: -- Bug 5624487
791: insert into fii_time_month
792: (month_id,
793: quarter_id,
794: name,
795: start_date,

Line 2719: truncate_table('FII_TIME_MONTH');

2715: fii_util.put_line('LOAD : '||'This is an initial load, all tables will be truncated and re-populated.');
2716: end if;
2717:
2718: truncate_table('FII_TIME_DAY');
2719: truncate_table('FII_TIME_MONTH');
2720: truncate_table('FII_TIME_QTR');
2721: truncate_table('FII_TIME_YEAR');
2722: truncate_table('FII_TIME_WEEK');
2723: truncate_table('FII_TIME_P445');

Line 3086: gather_table_stats('FII_TIME_MONTH');

3082: end if;
3083:
3084: -- note: we don't gather stats on FII_TIME_DAY
3085: -- as this should be done by RSG
3086: gather_table_stats('FII_TIME_MONTH');
3087:
3088: if g_debug_flag = 'Y' then
3089: fii_util.put_line('Gathered statistics for Month Level');
3090: end if;