360: select -- Resource Management
361: org.ORGANIZATION_ID
362: from
363: (
364: select /*+ index_ffs(org, PA_ALL_ORGANIZATIONS_U1)
365: parallel_index(org, PA_ALL_ORGANIZATIONS_U1) */
366: distinct
367: org.ORGANIZATION_ID
368: from
361: org.ORGANIZATION_ID
362: from
363: (
364: select /*+ index_ffs(org, PA_ALL_ORGANIZATIONS_U1)
365: parallel_index(org, PA_ALL_ORGANIZATIONS_U1) */
366: distinct
367: org.ORGANIZATION_ID
368: from
369: PA_ALL_ORGANIZATIONS org
365: parallel_index(org, PA_ALL_ORGANIZATIONS_U1) */
366: distinct
367: org.ORGANIZATION_ID
368: from
369: PA_ALL_ORGANIZATIONS org
370: where
371: p_settings_util_flag = 'Y' and
372: p_params_util_flag = 'N'
373: ) org