APPS.PA_RBS_MAPPING dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 1934: WITH gmap as (select * from PJI_PJP_PROJ_BATCH_MAP MAP

1930: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;
1931:
1932: --Commented the above insert and adding below for VTT 10246359
1933: INSERT INTO PA_RBS_MAP_T1 (WORKER_ID , PROJECT_ID , TXN_ACCUM_HEADER_ID)
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) */