498: acp.CALENDAR_TYPE = 'C'
499: )org
500: ) org,
501: (
502: select /*+ index_ffs(denorm, PJI_ORG_DENORM_N1)
503: parallel_index(denorm, PJI_ORG_DENORM_N1) */
504: distinct
505: denorm.ORGANIZATION_ID
506: from
499: )org
500: ) org,
501: (
502: select /*+ index_ffs(denorm, PJI_ORG_DENORM_N1)
503: parallel_index(denorm, PJI_ORG_DENORM_N1) */
504: distinct
505: denorm.ORGANIZATION_ID
506: from
507: PJI_ORG_DENORM denorm
503: parallel_index(denorm, PJI_ORG_DENORM_N1) */
504: distinct
505: denorm.ORGANIZATION_ID
506: from
507: PJI_ORG_DENORM denorm
508: where
509: (p_params_cost_flag = 'Y' or
510: p_params_profit_flag = 'Y' or
511: p_params_util_flag = 'Y')