APPS.PJI_FM_SUM_MAIN dependencies on PJI_XBS_DENORM

Line 603: select /*+ index (prg, PJI_XBS_DENORM_N3) */

599: ver2.PROJECT_ID = map.PROJECT_ID and
600: ver2.PRG_GROUP is not null
601: )
602: union
603: select /*+ index (prg, PJI_XBS_DENORM_N3) */
604: prg.SUP_PROJECT_ID PROJECT_ID
605: from
606: PJI_XBS_DENORM prg
607: where

Line 606: PJI_XBS_DENORM prg

602: union
603: select /*+ index (prg, PJI_XBS_DENORM_N3) */
604: prg.SUP_PROJECT_ID PROJECT_ID
605: from
606: PJI_XBS_DENORM prg
607: where
608: prg.STRUCT_TYPE = 'PRG' and
609: prg.SUB_LEVEL = prg.SUP_LEVEL and
610: prg.PRG_GROUP in