[Home] [Help]
4533: PRA.CBS_ELEMENT_ID
4534: FROM PA_RES_LIST_MAP_TMP4 T,
4535: PA_TASKS PAT,
4536: PA_RESOURCE_ASSIGNMENTS PRA,
4537: PA_ALTERNATE_TASKS PALT
4538: WHERE NVL(T.TXN_TASK_ID,0) > 0
4539: AND NVL(T.TXN_TASK_ID,0) = PAT.TASK_ID
4540: AND PALT.CBS_ELEMENT_ID = PRA.CBS_ELEMENT_ID
4541: AND PALT.PROJ_ELEMENT_ID = NVL(PAT.TOP_TASK_ID,0)
4637: PRA.CBS_ELEMENT_ID cbs_element_id
4638: FROM PA_RES_LIST_MAP_TMP4 T,
4639: PA_MAP_WP_TO_FIN_TASKS_V V1,
4640: PA_RESOURCE_ASSIGNMENTS PRA,
4641: PA_ALTERNATE_TASKS PAT
4642: WHERE NOT EXISTS
4643: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4644: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V
4645: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID