DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FP_TXN_ACCUM1

Line 7091: PJI_FP_TXN_ACCUM1 bal,

7087: to_number(null) QUANTITY,
7088: to_number(null) BILL_QUANTITY
7089: from
7090: PJI_PJP_PROJ_BATCH_MAP map,
7091: PJI_FP_TXN_ACCUM1 bal,
7092: PJI_PJP_RBS_HEADER rbs_hdr
7093: where
7094: l_extraction_type in ('FULL', 'PARTIAL') and
7095: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574

Line 7332: PJI_FP_TXN_ACCUM1 bal,

7328: bal.G2_OTH_COMMITTED_COST,
7329: to_number(null) QUANTITY,
7330: to_number(null) BILL_QUANTITY
7331: from
7332: PJI_FP_TXN_ACCUM1 bal,
7333: (
7334: select
7335: distinct
7336: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,

Line 7500: PJI_FP_TXN_ACCUM1 bal

7496: to_number(null) BILL_QUANTITY
7497: from
7498: PJI_PA_PROJ_EVENTS_LOG log,
7499: PJI_PJP_PROJ_EXTR_STATUS stat,
7500: PJI_FP_TXN_ACCUM1 bal
7501: where
7502: l_extraction_type = 'RBS' and
7503: log.WORKER_ID = p_worker_id and
7504: log.EVENT_TYPE = 'RBS_PUSH' and