DBA Data[Home] [Help]

APPS.PJI_AUDIT_RPT dependencies on PA_ALL_ORGANIZATIONS

Line 364: select /*+ index_ffs(org, PA_ALL_ORGANIZATIONS_U1)

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

Line 365: parallel_index(org, PA_ALL_ORGANIZATIONS_U1) */

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

Line 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