APPS.PJI_FM_SUM_ROLLUP_FIN dependencies on PJI_FM_AGGR_PLN

Line 2040: PJI_FM_AGGR_PLN tmp1

2036: sum(tmp1.CURR_FORECAST_LABOR_HRS) FORECAST_LABOR_HRS
2037: from
2038: FII_TIME_ENT_PERIOD period,
2039: FII_TIME_ENT_QTR qtr,
2040: PJI_FM_AGGR_PLN tmp1
2041: where
2042: tmp1.CALENDAR_TYPE_CODE = 'ENT' and
2043: tmp1.CURR_RECORD_TYPE_ID not in (8, 256) and
2044: tmp1.TIME_ID = period.ENT_PERIOD_ID and

Line 2428: PJI_FM_AGGR_PLN tmp1

2424: sum(tmp1.CURR_FORECAST_LABOR_HRS) FORECAST_LABOR_HRS
2425: from
2426: FII_TIME_CAL_PERIOD period,
2427: FII_TIME_CAL_QTR qtr,
2428: PJI_FM_AGGR_PLN tmp1
2429: where
2430: tmp1.CALENDAR_TYPE_CODE = 'PA' and
2431: tmp1.TIME_ID = period.CAL_PERIOD_ID and
2432: period.CAL_QTR_ID = qtr.CAL_QTR_ID

Line 2818: PJI_FM_AGGR_PLN tmp1

2814: sum(tmp1.CURR_FORECAST_LABOR_HRS) FORECAST_LABOR_HRS
2815: from
2816: FII_TIME_CAL_PERIOD period,
2817: FII_TIME_CAL_QTR qtr,
2818: PJI_FM_AGGR_PLN tmp1
2819: where
2820: tmp1.CALENDAR_TYPE_CODE = 'GL' and
2821: tmp1.TIME_ID = period.CAL_PERIOD_ID and
2822: period.CAL_QTR_ID = qtr.CAL_QTR_ID

Line 3149: PJI_FM_AGGR_PLN tmp1

3145: sum(tmp1.CURR_FORECAST_RAW_COST) FORECAST_RAW_COST,
3146: sum(tmp1.CURR_FORECAST_BRDN_COST) FORECAST_BURDENED_COST,
3147: sum(tmp1.CURR_FORECAST_LABOR_HRS) FORECAST_LABOR_HRS
3148: from
3149: PJI_FM_AGGR_PLN tmp1
3150: where
3151: tmp1.CALENDAR_TYPE_CODE = 'ENTW' and
3152: tmp1.CURR_RECORD_TYPE_ID not in (8, 256)
3153: group by

Line 3277: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_PLN' , 'NORMAL',null);

3273: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_WK(p_worker_id);');
3274:
3275: -- truncate intermediate tables no longer required
3276: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3277: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_PLN' , 'NORMAL',null);
3278:
3279: commit;
3280:
3281: end EXPAND_FPP_CAL_WK;