APPS.PA_RBS_MAPPING dependencies on PJI_FM_AGGR_FIN7

Line 1925: --SELECT /*+ ORDERED index(fin7 pji_fm_aggr_fin7_n1) */

1921: project_id,
1922: txn_accum_header_id
1923: FROM
1924: (
1925: --SELECT /*+ ORDERED index(fin7 pji_fm_aggr_fin7_n1) */
1926: SELECT /*+ ORDERED USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */ --AECOM added ordered and use_nl bug 6739719
1927: fin7.project_id,
1928: txn_accum_header_id
1929: FROM

Line 1926: SELECT /*+ ORDERED USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */ --AECOM added ordered and use_nl bug 6739719

1922: txn_accum_header_id
1923: FROM
1924: (
1925: --SELECT /*+ ORDERED index(fin7 pji_fm_aggr_fin7_n1) */
1926: SELECT /*+ ORDERED USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */ --AECOM added ordered and use_nl bug 6739719
1927: fin7.project_id,
1928: txn_accum_header_id
1929: FROM
1930: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix

Line 1931: pji_fm_aggr_fin7 fin7

1927: fin7.project_id,
1928: txn_accum_header_id
1929: FROM
1930: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix
1931: pji_fm_aggr_fin7 fin7
1932: WHERE fin7.project_id = map.project_id
1933: AND map.worker_id = p_worker_id
1934: AND fin7.recvr_period_type='GL'
1935: UNION ALL