DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FM_AGGR_FIN7

Line 7171: PJI_FM_AGGR_FIN7 tmp7,

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
7175: tmp7_r.WORKER_ID = p_worker_id and

Line 8373: PJI_FM_AGGR_FIN7 fin7

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);
8377: