APPS.PJI_FM_SUM_ROLLUP_FIN dependencies on FII_TIME_DAY

Line 893: FII_TIME_DAY time,

889: sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS,
890: sum(fin.QUANTITY) QUANTITY,
891: sum(fin.BILL_QUANTITY) BILL_QUANTITY
892: from
893: FII_TIME_DAY time,
894: PJI_FM_AGGR_FIN4 fin
895: where
896: fin.WORKER_ID = p_worker_id and
897: fin.PERIOD_TYPE_ID = 1 and

Line 1274: FII_TIME_DAY time,

1270: sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS,
1271: sum(fin.QUANTITY) QUANTITY,
1272: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1273: from
1274: FII_TIME_DAY time,
1275: PJI_FM_AGGR_FIN4 fin
1276: where
1277: fin.WORKER_ID = p_worker_id and
1278: fin.PERIOD_TYPE_ID = 1 and

Line 1398: FII_TIME_DAY time,

1394: sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS,
1395: sum(fin.QUANTITY) QUANTITY,
1396: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1397: from
1398: FII_TIME_DAY time,
1399: PJI_FM_AGGR_FIN5 fin
1400: where
1401: fin.WORKER_ID = p_worker_id and
1402: fin.PERIOD_TYPE_ID = 1 and

Line 1770: FII_TIME_DAY time,

1766: sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS,
1767: sum(fin.QUANTITY) QUANTITY,
1768: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1769: from
1770: FII_TIME_DAY time,
1771: PJI_FM_AGGR_FIN5 fin
1772: where
1773: fin.WORKER_ID = p_worker_id and
1774: fin.PERIOD_TYPE_ID = 1 and

Line 1952: FII_TIME_DAY time,

1948: to_number(null) FORECAST_RAW_COST,
1949: to_number(null) FORECAST_BURDENED_COST,
1950: to_number(null) FORECAST_LABOR_HRS
1951: from
1952: FII_TIME_DAY time,
1953: PJI_FM_AGGR_FIN3 fin
1954: where
1955: fin.WORKER_ID = p_worker_id and
1956: fin.PERIOD_TYPE_ID = 1 and

Line 3096: FII_TIME_DAY time,

3092: to_number(null) FORECAST_RAW_COST,
3093: to_number(null) FORECAST_BURDENED_COST,
3094: to_number(null) FORECAST_LABOR_HRS
3095: from
3096: FII_TIME_DAY time,
3097: PJI_FM_AGGR_FIN3 fin
3098: where
3099: fin.WORKER_ID = p_worker_id and
3100: fin.PERIOD_TYPE_ID = 1 and