487: where
488: p_params_cost_flag = 'Y' and
489: fpp.CALENDAR_TYPE = 'C'
490: union all
491: select /*+ index_ffs(acp, PJI_AC_PROJ_F_N1)
492: parallel_index(acp, PJI_AC_PROJ_F_N1) */
493: acp.PROJECT_ORGANIZATION_ID ORGANIZATION_ID
494: from
495: PJI_AC_PROJ_F acp
488: p_params_cost_flag = 'Y' and
489: fpp.CALENDAR_TYPE = 'C'
490: union all
491: select /*+ index_ffs(acp, PJI_AC_PROJ_F_N1)
492: parallel_index(acp, PJI_AC_PROJ_F_N1) */
493: acp.PROJECT_ORGANIZATION_ID ORGANIZATION_ID
494: from
495: PJI_AC_PROJ_F acp
496: where
491: select /*+ index_ffs(acp, PJI_AC_PROJ_F_N1)
492: parallel_index(acp, PJI_AC_PROJ_F_N1) */
493: acp.PROJECT_ORGANIZATION_ID ORGANIZATION_ID
494: from
495: PJI_AC_PROJ_F acp
496: where
497: p_params_profit_flag = 'Y' and
498: acp.CALENDAR_TYPE = 'C'
499: )org