APPS.PA_RBS_MAPPING dependencies on PJI_FP_TXN_ACCUM1

Line 1952: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/

1948: PJI_FP_TXN_ACCUM ACCUM
1949: WHERE ACCUM.PROJECT_ID = MAP.PROJECT_ID
1950: AND ACCUM.RECVR_PERIOD_TYPE='GL'
1951: UNION ALL
1952: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/
1953: ACCUM1.PROJECT_ID, TXN_ACCUM_HEADER_ID
1954: FROM gmap MAP,
1955: PJI_FP_TXN_ACCUM1 ACCUM1
1956: WHERE ACCUM1.PROJECT_ID = MAP.PROJECT_ID

Line 1955: PJI_FP_TXN_ACCUM1 ACCUM1

1951: UNION ALL
1952: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/
1953: ACCUM1.PROJECT_ID, TXN_ACCUM_HEADER_ID
1954: FROM gmap MAP,
1955: PJI_FP_TXN_ACCUM1 ACCUM1
1956: WHERE ACCUM1.PROJECT_ID = MAP.PROJECT_ID
1957: UNION ALL
1958: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) index ( wbs pji_pjp_wbs_header_n1 ) */
1959: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID

Line 2337: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/

2333: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2334: AND ACCUM.RECVR_PERIOD_TYPE='GL'
2335: AND ACCUM.project_id = p_project_id
2336: UNION ALL
2337: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/
2338: ACCUM1.PROJECT_ID, TXN_ACCUM_HEADER_ID
2339: FROM PJI_FP_TXN_ACCUM1 ACCUM1
2340: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2341: AND ACCUM1.PROJECT_ID = p_project_id

Line 2339: FROM PJI_FP_TXN_ACCUM1 ACCUM1

2335: AND ACCUM.project_id = p_project_id
2336: UNION ALL
2337: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/
2338: ACCUM1.PROJECT_ID, TXN_ACCUM_HEADER_ID
2339: FROM PJI_FP_TXN_ACCUM1 ACCUM1
2340: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2341: AND ACCUM1.PROJECT_ID = p_project_id
2342: UNION ALL
2343: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) */