APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_PJP_RMAP_FPR

Line 7170: (select distinct STG_ROWID, worker_id from PJI_PJP_RMAP_FPR) tmp7_r, -- Added for bug 16383776

7166: tmp7.G2_OTH_COMMITTED_COST,
7167: tmp7.QUANTITY,
7168: tmp7.BILL_QUANTITY
7169: from
7170: (select distinct STG_ROWID, worker_id from PJI_PJP_RMAP_FPR) tmp7_r, -- Added for bug 16383776
7171: PJI_FM_AGGR_FIN7 tmp7,
7172: PJI_PJP_RBS_HEADER rbs_hdr
7173: where
7174: l_extraction_type = 'INCREMENTAL' and

Line 8372: from PJI_PJP_RMAP_FPR fin7_r,

8368: update PJI_PJP_PROJ_BATCH_MAP map
8369: set map.EXTRACTION_TYPE = 'M'
8370: where map.WORKER_ID = p_worker_id and
8371: map.PROJECT_ID in (select fin7.PROJECT_ID
8372: from PJI_PJP_RMAP_FPR fin7_r,
8373: PJI_FM_AGGR_FIN7 fin7
8374: where fin7_r.WORKER_ID = p_worker_id and
8375: fin7_r.RECORD_TYPE = 'M' and
8376: fin7.ROWID = fin7_r.STG_ROWID);

Line 20300: 'PJI_PJP_RMAP_FPR',

20296: l_ctr := i;
20297: begin
20298: if l_tab1 = 'N' then
20299: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
20300: 'PJI_PJP_RMAP_FPR',
20301: 'PARTITION',
20302: 'P' || p_worker_id);
20303: l_tab1 := 'Y';
20304: end if;