APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FP_TXN_ACCUM

Line 3752: PJI_FP_TXN_ACCUM bal,

3748: bal.QUANTITY,
3749: bal.BILL_QUANTITY
3750: from
3751: PJI_PJP_PROJ_BATCH_MAP map,
3752: PJI_FP_TXN_ACCUM bal,
3753: PJI_PJP_RBS_HEADER rbs_hdr
3754: where
3755: l_extraction_type in ('FULL', 'PARTIAL') and
3756: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574

Line 3832: PJI_FP_TXN_ACCUM1 bal,

3828: to_number(null) QUANTITY,
3829: to_number(null) BILL_QUANTITY
3830: from
3831: PJI_PJP_PROJ_BATCH_MAP map,
3832: PJI_FP_TXN_ACCUM1 bal,
3833: PJI_PJP_RBS_HEADER rbs_hdr
3834: where
3835: l_extraction_type in ('FULL', 'PARTIAL') and
3836: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574

Line 3989: PJI_FP_TXN_ACCUM bal,

3985: to_number(null) G2_OTH_COMMITTED_COST,
3986: bal.QUANTITY,
3987: bal.BILL_QUANTITY
3988: from
3989: PJI_FP_TXN_ACCUM bal,
3990: (
3991: select
3992: distinct
3993: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,

Line 4073: PJI_FP_TXN_ACCUM1 bal,

4069: bal.G2_OTH_COMMITTED_COST,
4070: to_number(null) QUANTITY,
4071: to_number(null) BILL_QUANTITY
4072: from
4073: PJI_FP_TXN_ACCUM1 bal,
4074: (
4075: select
4076: distinct
4077: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,

Line 4159: PJI_FP_TXN_ACCUM bal

4155: bal.BILL_QUANTITY
4156: from
4157: PJI_PA_PROJ_EVENTS_LOG log,
4158: PJI_PJP_PROJ_EXTR_STATUS stat,
4159: PJI_FP_TXN_ACCUM bal
4160: where
4161: l_extraction_type = 'RBS' and
4162: log.WORKER_ID = p_worker_id and
4163: log.EVENT_TYPE = 'RBS_PUSH' and

Line 4238: PJI_FP_TXN_ACCUM1 bal

4234: to_number(null) BILL_QUANTITY
4235: from
4236: PJI_PA_PROJ_EVENTS_LOG log,
4237: PJI_PJP_PROJ_EXTR_STATUS stat,
4238: PJI_FP_TXN_ACCUM1 bal
4239: where
4240: l_extraction_type = 'RBS' and
4241: log.WORKER_ID = p_worker_id and
4242: log.EVENT_TYPE = 'RBS_PUSH' and