APPS.PA_RBS_MAPPING dependencies on PJI_FM_AGGR_FIN7

Line 1938: SELECT /*+ ordered USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */

1934: WITH gmap as (select * from PJI_PJP_PROJ_BATCH_MAP MAP
1935: where MAP.WORKER_ID = p_worker_id )
1936: SELECT DISTINCT p_worker_id , PROJECT_ID, TXN_ACCUM_HEADER_ID
1937: FROM (
1938: SELECT /*+ ordered USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */
1939: FIN7.PROJECT_ID, TXN_ACCUM_HEADER_ID
1940: FROM gmap map,
1941: PJI_FM_AGGR_FIN7 FIN7
1942: WHERE FIN7.PROJECT_ID = MAP.PROJECT_ID

Line 1941: PJI_FM_AGGR_FIN7 FIN7

1937: FROM (
1938: SELECT /*+ ordered USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */
1939: FIN7.PROJECT_ID, TXN_ACCUM_HEADER_ID
1940: FROM gmap map,
1941: PJI_FM_AGGR_FIN7 FIN7
1942: WHERE FIN7.PROJECT_ID = MAP.PROJECT_ID
1943: AND FIN7.RECVR_PERIOD_TYPE='GL'
1944: UNION ALL
1945: SELECT /*+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)*/

Line 2323: SELECT /*+ ordered USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */

2319:
2320: INSERT INTO PA_RBS_MAP_T1 (WORKER_ID , PROJECT_ID , TXN_ACCUM_HEADER_ID)
2321: SELECT DISTINCT p_worker_id , PROJECT_ID, TXN_ACCUM_HEADER_ID
2322: FROM (
2323: SELECT /*+ ordered USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */
2324: FIN7.PROJECT_ID, TXN_ACCUM_HEADER_ID
2325: FROM PJI_FM_AGGR_FIN7 FIN7
2326: WHERE p_calling_mode in ( 'FULL', 'INCREMENTAL ' )
2327: AND FIN7.RECVR_PERIOD_TYPE='GL'

Line 2325: FROM PJI_FM_AGGR_FIN7 FIN7

2321: SELECT DISTINCT p_worker_id , PROJECT_ID, TXN_ACCUM_HEADER_ID
2322: FROM (
2323: SELECT /*+ ordered USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */
2324: FIN7.PROJECT_ID, TXN_ACCUM_HEADER_ID
2325: FROM PJI_FM_AGGR_FIN7 FIN7
2326: WHERE p_calling_mode in ( 'FULL', 'INCREMENTAL ' )
2327: AND FIN7.RECVR_PERIOD_TYPE='GL'
2328: AND FIN7.project_id = p_project_id
2329: UNION ALL