APPS.PJI_FM_SUM_MAIN dependencies on PJI_XBS_DENORM

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

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

Line 607: PJI_XBS_DENORM prg

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