APPS.PJI_FM_SUM_ROLLUP_FIN dependencies on FII_TIME_CAL_DAY_MV

Line 1029: FII_TIME_CAL_DAY_MV time,

1025: sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS,
1026: sum(fin.QUANTITY) QUANTITY,
1027: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1028: from
1029: FII_TIME_CAL_DAY_MV time,
1030: PJI_FM_AGGR_FIN4 fin
1031: where
1032: fin.WORKER_ID = p_worker_id and
1033: fin.PERIOD_TYPE_ID = 1 and

Line 1165: FII_TIME_CAL_DAY_MV time,

1161: sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS,
1162: sum(fin.QUANTITY) QUANTITY,
1163: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1164: from
1165: FII_TIME_CAL_DAY_MV time,
1166: PJI_FM_AGGR_FIN4 fin
1167: where
1168: fin.WORKER_ID = p_worker_id and
1169: fin.PERIOD_TYPE_ID = 1 and

Line 1531: FII_TIME_CAL_DAY_MV time,

1527: sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS,
1528: sum(fin.QUANTITY) QUANTITY,
1529: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1530: from
1531: FII_TIME_CAL_DAY_MV time,
1532: PJI_FM_AGGR_FIN5 fin
1533: where
1534: fin.WORKER_ID = p_worker_id and
1535: fin.PERIOD_TYPE_ID = 1 and

Line 1664: FII_TIME_CAL_DAY_MV time,

1660: sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS,
1661: sum(fin.QUANTITY) QUANTITY,
1662: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1663: from
1664: FII_TIME_CAL_DAY_MV time,
1665: PJI_FM_AGGR_FIN5 fin
1666: where
1667: fin.WORKER_ID = p_worker_id and
1668: fin.PERIOD_TYPE_ID = 1 and

Line 2340: FII_TIME_CAL_DAY_MV time,

2336: to_number(null) FORECAST_RAW_COST,
2337: to_number(null) FORECAST_BURDENED_COST,
2338: to_number(null) FORECAST_LABOR_HRS
2339: from
2340: FII_TIME_CAL_DAY_MV time,
2341: PJI_FM_AGGR_FIN3 fin
2342: where
2343: fin.WORKER_ID = p_worker_id and
2344: fin.PERIOD_TYPE_ID = 1 and

Line 2730: FII_TIME_CAL_DAY_MV time,

2726: to_number(null) FORECAST_RAW_COST,
2727: to_number(null) FORECAST_BURDENED_COST,
2728: to_number(null) FORECAST_LABOR_HRS
2729: from
2730: FII_TIME_CAL_DAY_MV time,
2731: PJI_FM_AGGR_FIN3 fin
2732: where
2733: fin.WORKER_ID = p_worker_id and
2734: fin.PERIOD_TYPE_ID = 1 and