APPS.HRI_TIME_C dependencies on HRI_TIME_QTR

Line 878: select min(start_date) into l_min_date from HRI_time_qtr;

874: --Used a decode for the same
875: l_min_date := p_from_date;
876: ELSE
877: -- Incremental run
878: select min(start_date) into l_min_date from HRI_time_qtr;
879: END IF;
880:
881: -- Bug 5624487
882: -- delete from HRI_TIME_QTR where start_date <= l_to_date and end_date >= l_from_date;

Line 882: -- delete from HRI_TIME_QTR where start_date <= l_to_date and end_date >= l_from_date;

878: select min(start_date) into l_min_date from HRI_time_qtr;
879: END IF;
880:
881: -- Bug 5624487
882: -- delete from HRI_TIME_QTR where start_date <= l_to_date and end_date >= l_from_date;
883: delete from HRI_TIME_QTR
884: where start_date <= l_to_date and end_date >= l_from_date
885: or end_date >= g_unassigned_day;
886:

Line 883: delete from HRI_TIME_QTR

879: END IF;
880:
881: -- Bug 5624487
882: -- delete from HRI_TIME_QTR where start_date <= l_to_date and end_date >= l_from_date;
883: delete from HRI_TIME_QTR
884: where start_date <= l_to_date and end_date >= l_from_date
885: or end_date >= g_unassigned_day;
886:
887: -- ----------------------

Line 899: insert into HRI_time_qtr

895: end if;
896: while l_qtr <= l_to_date or l_qtr_end = g_unassigned_day loop
897:
898: -- Bug 5624487
899: insert into HRI_time_qtr
900: (quarter_id,
901: year_id,
902: name,
903: start_date,

Line 2720: truncate_table('HRI_TIME_QTR');

2716: end if;
2717:
2718: truncate_table('HRI_TIME_DAY');
2719: truncate_table('HRI_TIME_MONTH');
2720: truncate_table('HRI_TIME_QTR');
2721: truncate_table('HRI_TIME_YEAR');
2722: truncate_table('HRI_TIME_WEEK');
2723: truncate_table('HRI_TIME_P445');
2724: truncate_table('HRI_TIME_YEAR445');

Line 3092: gather_table_stats('HRI_TIME_QTR');

3088: if g_debug_flag = 'Y' then
3089: HRI_util.put_line('Gathered statistics for Month Level');
3090: end if;
3091:
3092: gather_table_stats('HRI_TIME_QTR');
3093:
3094: if g_debug_flag = 'Y' then
3095: HRI_util.put_line('Gathered statistics for Quarter Level');
3096: end if;