DBA Data[Home] [Help]

APPS.HRI_TIME_C dependencies on HRI_TIME_ROLLING_OFFSETS

Line 2735: truncate_table('HRI_TIME_ROLLING_OFFSETS');

2731: truncate_table('HRI_TIME_CAL_YEAR');
2732: truncate_table('HRI_TIME_RPT_STRUCT');
2733: truncate_table('HRI_TIME_CAL_RPT_STRUCT');
2734: truncate_table('HRI_TIME_STRUCTURES');
2735: truncate_table('HRI_TIME_ROLLING_OFFSETS');
2736: else
2737: -- if it is incremental loading, check if there is any modified period
2738: -- if there is any modified period, do initial load of the enterprise tables
2739: if g_debug_flag = 'Y' then

Line 3056: from HRI_time_rolling_offsets

3052: l_count := 0;
3053: -- Bug 4966868: Changed not to count rows
3054: begin
3055: select 1 into l_count
3056: from HRI_time_rolling_offsets
3057: where rownum = 1;
3058: exception
3059: when no_data_found then
3060: l_count := 0;