APPS.HRI_TIME_C dependencies on HRI_TIME_CAL_YEAR

Line 2396: HRI_time_cal_year

2392: , name
2393: , start_date
2394: , end_date
2395: from
2396: HRI_time_cal_year
2397: )
2398: union all
2399: (select
2400: cal_year_id

Line 2407: HRI_time_cal_year

2403: , name
2404: , start_date
2405: , end_date
2406: from
2407: HRI_time_cal_year
2408: minus
2409: select
2410: distinct to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year)
2411: , to_number(lpad(cal_name.calendar_id,3,'0'))

Line 2461: truncate_table('HRI_TIME_CAL_YEAR');

2457: return;
2458:
2459: end if;
2460:
2461: truncate_table('HRI_TIME_CAL_YEAR');
2462:
2463: -- ---------------------------------------------------------
2464: -- Variable initialization
2465: -- ---------------------------------------------------------

Line 2471: insert into HRI_time_cal_year

2467:
2468: -- ----------------------
2469: -- Populate Financial Year Level
2470: -- ----------------------
2471: insert into HRI_time_cal_year
2472: (cal_year_id,
2473: calendar_id,
2474: sequence,
2475: name,

Line 2515: gather_table_stats('HRI_TIME_CAL_YEAR');

2511: if g_debug_flag = 'Y' then
2512: HRI_util.put_line('LOAD_CAL_YEAR : '||to_char(l_year_row)||' records has been populated to Financial Year Level');
2513: end if;
2514:
2515: gather_table_stats('HRI_TIME_CAL_YEAR');
2516:
2517: if g_debug_flag = 'Y' then
2518: HRI_util.put_line('LOAD_CAL_YEAR : '||'Gathered statistics for Financial Year Level');
2519: end if;

Line 2731: truncate_table('HRI_TIME_CAL_YEAR');

2727: truncate_table('HRI_TIME_ENT_YEAR');
2728: truncate_table('HRI_TIME_CAL_NAME');
2729: truncate_table('HRI_TIME_CAL_PERIOD');
2730: truncate_table('HRI_TIME_CAL_QTR');
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');

Line 3122: truncate_table('HRI_TIME_CAL_YEAR');

3118: truncate_table('HRI_TIME_ENT_QTR');
3119: truncate_table('HRI_TIME_ENT_YEAR');
3120: truncate_table('HRI_TIME_CAL_PERIOD');
3121: truncate_table('HRI_TIME_CAL_QTR');
3122: truncate_table('HRI_TIME_CAL_YEAR');
3123: truncate_table('HRI_TIME_RPT_STRUCT');
3124: truncate_table('HRI_TIME_CAL_RPT_STRUCT');
3125:
3126: if g_debug_flag = 'Y' then

Line 4114: FROM HRI_TIME_CAL_YEAR

4110: , SYSDATE
4111: , g_user_id
4112: , g_user_id
4113: , g_login_id
4114: FROM HRI_TIME_CAL_YEAR
4115: WHERE calendar_id = cur_Fiscal_Days.calendar_id
4116: AND cur_Fiscal_Days.report_date BETWEEN start_date AND end_date
4117: UNION ALL
4118: SELECT

Line 4130: FROM HRI_TIME_CAL_YEAR

4126: , SYSDATE
4127: , g_user_id
4128: , g_user_id
4129: , g_login_id
4130: FROM HRI_TIME_CAL_YEAR
4131: WHERE calendar_id = cur_Fiscal_Days.calendar_id
4132: AND end_date < cur_Fiscal_Days.report_date
4133: AND end_date >= g_global_start_date;
4134: