APPS.PA_RBS_MAPPING dependencies on PJI_XBS_DENORM

Line 1986: SELECT /*+ ORDERED index(den PJI_XBS_DENORM_N1)*/ -- Bug#5578221 - Peformance Fix

1982: wbs.wp_flag = 'N' AND
1983: ra.txn_accum_header_id IS NOT NULL AND
1984: LOG.worker_id = p_worker_id
1985: UNION ALL
1986: SELECT /*+ ORDERED index(den PJI_XBS_DENORM_N1)*/ -- Bug#5578221 - Peformance Fix
1987: DISTINCT
1988: ra.project_id,
1989: ra.txn_accum_header_id
1990: FROM

Line 2004: pji_xbs_denorm den

2000: , event_type
2001: , attribute1
2002: FROM pa_pji_proj_events_log
2003: )LOG,
2004: pji_xbs_denorm den
2005: WHERE
2006: l_rbs_prg_flag = 'Y' and --AECOM Change bug 6739719
2007: map.worker_id = p_worker_id and
2008: map.project_id = hd2.project_id and