DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_PJP_RMAP_FPR

Line 3911: PJI_PJP_RMAP_FPR tmp7_r,

3907: tmp7.G2_OTH_COMMITTED_COST,
3908: tmp7.QUANTITY,
3909: tmp7.BILL_QUANTITY
3910: from
3911: PJI_PJP_RMAP_FPR tmp7_r,
3912: PJI_FM_AGGR_FIN7 tmp7,
3913: PJI_PJP_RBS_HEADER rbs_hdr
3914: where
3915: l_extraction_type = 'INCREMENTAL' and

Line 5105: from PJI_PJP_RMAP_FPR fin7_r,

5101: update PJI_PJP_PROJ_BATCH_MAP map
5102: set map.EXTRACTION_TYPE = 'M'
5103: where map.WORKER_ID = p_worker_id and
5104: map.PROJECT_ID in (select fin7.PROJECT_ID
5105: from PJI_PJP_RMAP_FPR fin7_r,
5106: PJI_FM_AGGR_FIN7 fin7
5107: where fin7_r.WORKER_ID = p_worker_id and
5108: fin7_r.RECORD_TYPE = 'M' and
5109: fin7.ROWID = fin7_r.STG_ROWID);

Line 17985: 'PJI_PJP_RMAP_FPR',

17981:
17982: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
17983:
17984: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
17985: 'PJI_PJP_RMAP_FPR',
17986: 'PARTITION',
17987: 'P' || p_worker_id);
17988:
17989: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,