DBA Data[Home] [Help]

APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_PJI_PROJ_BATCH_MAP

Line 691: from PJI_PJI_PROJ_BATCH_MAP map1

687: wt_new.WORK_TYPE_ID = rmr.WORK_TYPE_ID and
688: (rmr.PROJECT_ID in
689: (select /*+ full(map1) */
690: PROJECT_ID
691: from PJI_PJI_PROJ_BATCH_MAP map1
692: where WORKER_ID = p_worker_id) or
693: rmr.EXPENDITURE_ORGANIZATION_ID in
694: (select /*+ full(map2) */
695: ORGANIZATION_ID