DBA Data[Home] [Help]

APPS.PJI_AUDIT_RPT dependencies on PJI_AC_PROJ_F

Line 491: select /*+ index_ffs(acp, PJI_AC_PROJ_F_N1)

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

Line 492: parallel_index(acp, PJI_AC_PROJ_F_N1) */

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

Line 495: PJI_AC_PROJ_F acp

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