478: PJI_RM_RES_WT_F rmr
479: where
480: p_params_util_flag = 'Y'
481: union all
482: select /*+ index_ffs(fpp, PJI_FP_PROJ_F_N1)
483: parallel_index(fpp, PJI_FP_PROJ_F_N1) */
484: fpp.PROJECT_ORGANIZATION_ID ORGANIZATION_ID
485: from
486: PJI_FP_PROJ_F fpp
479: where
480: p_params_util_flag = 'Y'
481: union all
482: select /*+ index_ffs(fpp, PJI_FP_PROJ_F_N1)
483: parallel_index(fpp, PJI_FP_PROJ_F_N1) */
484: fpp.PROJECT_ORGANIZATION_ID ORGANIZATION_ID
485: from
486: PJI_FP_PROJ_F fpp
487: where
482: select /*+ index_ffs(fpp, PJI_FP_PROJ_F_N1)
483: parallel_index(fpp, PJI_FP_PROJ_F_N1) */
484: fpp.PROJECT_ORGANIZATION_ID ORGANIZATION_ID
485: from
486: PJI_FP_PROJ_F fpp
487: where
488: p_params_cost_flag = 'Y' and
489: fpp.CALENDAR_TYPE = 'C'
490: union all