DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FP_TXN_ACCUM1

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 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 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