APPS.PJI_RM_SUM_ROLLUP_RES dependencies on FII_TIME_CAL_DAY_MV

Line 978: FII_TIME_CAL_DAY_MV time,

974: sum(tmp1.UNASSIGNED_HRS_S) UNASSIGNED_HRS_S,
975: sum(tmp1.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
976: sum(tmp1.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
977: from
978: FII_TIME_CAL_DAY_MV time,
979: PJI_RM_AGGR_RES1 tmp1
980: where
981: tmp1.WORKER_ID = p_worker_id and
982: tmp1.RECORD_TYPE <> 'N' and

Line 1127: FII_TIME_CAL_DAY_MV time,

1123: sum(tmp1.UNASSIGNED_HRS_S) UNASSIGNED_HRS_S,
1124: sum(tmp1.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
1125: sum(tmp1.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
1126: from
1127: FII_TIME_CAL_DAY_MV time,
1128: PJI_RM_AGGR_RES1 tmp1
1129: where
1130: tmp1.WORKER_ID = p_worker_id and
1131: tmp1.RECORD_TYPE <> 'N' and

Line 1639: FII_TIME_CAL_DAY_MV time,

1635: sum(tmp2.AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S,
1636: sum(tmp2.AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S,
1637: sum(tmp2.TOTAL_RES_COUNT) TOTAL_RES_COUNT
1638: from
1639: FII_TIME_CAL_DAY_MV time,
1640: PJI_RM_AGGR_RES2 tmp2
1641: where
1642: tmp2.WORKER_ID = p_worker_id and
1643: tmp2.PERIOD_TYPE_ID = 1 and

Line 1845: FII_TIME_CAL_DAY_MV time,

1841: sum(tmp2.AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S,
1842: sum(tmp2.AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S,
1843: sum(tmp2.TOTAL_RES_COUNT) TOTAL_RES_COUNT
1844: from
1845: FII_TIME_CAL_DAY_MV time,
1846: PJI_RM_AGGR_RES2 tmp2
1847: where
1848: tmp2.WORKER_ID = p_worker_id and
1849: tmp2.PERIOD_TYPE_ID = 1 and