APPS.PA_RBS_MAPPING dependencies on PJI_FP_TXN_ACCUM1

Line 1947: --SELECT /*+ ORDERED index(accum1 pji_fp_txn_accum1_n1)*/

1943: WHERE accum.project_id = map.project_id
1944: AND map.worker_id = p_worker_id
1945: AND accum.recvr_period_type='GL'
1946: UNION ALL
1947: --SELECT /*+ ORDERED index(accum1 pji_fp_txn_accum1_n1)*/
1948: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/ --AECOM added ordered and use_nl bug 6739719
1949: accum1.project_id,
1950: txn_accum_header_id
1951: FROM

Line 1948: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/ --AECOM added ordered and use_nl bug 6739719

1944: AND map.worker_id = p_worker_id
1945: AND accum.recvr_period_type='GL'
1946: UNION ALL
1947: --SELECT /*+ ORDERED index(accum1 pji_fp_txn_accum1_n1)*/
1948: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/ --AECOM added ordered and use_nl bug 6739719
1949: accum1.project_id,
1950: txn_accum_header_id
1951: FROM
1952: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix

Line 1953: pji_fp_txn_accum1 accum1

1949: accum1.project_id,
1950: txn_accum_header_id
1951: FROM
1952: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix
1953: pji_fp_txn_accum1 accum1
1954: WHERE accum1.project_id = map.project_id
1955: AND map.worker_id = p_worker_id
1956: UNION ALL
1957: SELECT /*+ORDERED*/DISTINCT