APPS.FII_TIME_C dependencies on FII_TIME_CAL_QTR

Line 2192: fii_time_cal_qtr

2188: , name
2189: , start_date
2190: , end_date
2191: from
2192: fii_time_cal_qtr
2193: )
2194: union all
2195: (select
2196: cal_qtr_id

Line 2204: fii_time_cal_qtr

2200: , name
2201: , start_date
2202: , end_date
2203: from
2204: fii_time_cal_qtr
2205: minus
2206: select
2207: distinct to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year||glp.quarter_num)
2208: , to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year)

Line 2265: truncate_table('FII_TIME_CAL_QTR');

2261: return;
2262:
2263: end if;
2264:
2265: truncate_table('FII_TIME_CAL_QTR');
2266:
2267: -- ---------------------------------------------------------
2268: -- Variable initialization
2269: -- ---------------------------------------------------------

Line 2275: insert into fii_time_cal_qtr

2271:
2272: -- ----------------------
2273: -- Populate Financial Quarter Level
2274: -- ----------------------
2275: insert into fii_time_cal_qtr
2276: (cal_qtr_id,
2277: cal_year_id,
2278: calendar_id,
2279: sequence,

Line 2326: gather_table_stats('FII_TIME_CAL_QTR');

2322: if g_debug_flag = 'Y' then
2323: fii_util.put_line('LOAD_CAL_QUARTER : '||to_char(l_qtr_row)||' records has been populated to Financial Quarter Level');
2324: end if;
2325:
2326: gather_table_stats('FII_TIME_CAL_QTR');
2327:
2328: if g_debug_flag = 'Y' then
2329: fii_util.put_line('LOAD_CAL_QUARTER : '||'Gathered statistics for Financial Quarter Level');
2330: end if;

Line 2730: truncate_table('FII_TIME_CAL_QTR');

2726: truncate_table('FII_TIME_ENT_QTR');
2727: truncate_table('FII_TIME_ENT_YEAR');
2728: truncate_table('FII_TIME_CAL_NAME');
2729: truncate_table('FII_TIME_CAL_PERIOD');
2730: truncate_table('FII_TIME_CAL_QTR');
2731: truncate_table('FII_TIME_CAL_YEAR');
2732: truncate_table('FII_TIME_RPT_STRUCT');
2733: truncate_table('FII_TIME_CAL_RPT_STRUCT');
2734: truncate_table('FII_TIME_STRUCTURES');

Line 3121: truncate_table('FII_TIME_CAL_QTR');

3117: truncate_table('FII_TIME_ENT_PERIOD');
3118: truncate_table('FII_TIME_ENT_QTR');
3119: truncate_table('FII_TIME_ENT_YEAR');
3120: truncate_table('FII_TIME_CAL_PERIOD');
3121: truncate_table('FII_TIME_CAL_QTR');
3122: truncate_table('FII_TIME_CAL_YEAR');
3123: truncate_table('FII_TIME_RPT_STRUCT');
3124: truncate_table('FII_TIME_CAL_RPT_STRUCT');
3125:

Line 4061: FROM FII_TIME_CAL_QTR

4057: , SYSDATE
4058: , g_user_id
4059: , g_user_id
4060: , g_login_id
4061: FROM FII_TIME_CAL_QTR
4062: WHERE start_date >= cur_Fiscal_Days.year_start_date
4063: AND start_date <= cur_Fiscal_Days.qtr_start_date
4064: AND end_date < cur_Fiscal_Days.report_date
4065: AND calendar_id = cur_Fiscal_Days.calendar_id

Line 4079: FROM FII_TIME_CAL_QTR

4075: , SYSDATE
4076: , g_user_id
4077: , g_user_id
4078: , g_login_id
4079: FROM FII_TIME_CAL_QTR
4080: WHERE start_date >= cur_Fiscal_Days.year_start_date
4081: AND start_date <= cur_Fiscal_Days.qtr_start_date
4082: AND end_date >= cur_Fiscal_Days.report_date
4083: AND calendar_id = cur_Fiscal_Days.calendar_id;