DBA Data[Home] [Help]

APPS.PJI_PJP_GEN_PERF_ALL dependencies on PJI_FP_TXN_ACCUM

Line 2152: PJI_FP_TXN_ACCUM bal,

2148: bal.QUANTITY,
2149: bal.BILL_QUANTITY
2150: from
2151: PJI_PJP_PROJ_BATCH_MAP map,
2152: PJI_FP_TXN_ACCUM bal,
2153: PJI_PJP_RBS_HEADER rbs_hdr
2154: where
2155: p_extraction_type in ('FULL', 'PARTIAL') and
2156: map.WORKER_ID = p_worker_id and

Line 2230: PJI_FP_TXN_ACCUM1 bal,

2226: to_number(null) QUANTITY,
2227: to_number(null) BILL_QUANTITY
2228: from
2229: PJI_PJP_PROJ_BATCH_MAP map,
2230: PJI_FP_TXN_ACCUM1 bal,
2231: PJI_PJP_RBS_HEADER rbs_hdr
2232: where
2233: p_extraction_type in ('FULL', 'PARTIAL') and
2234: map.WORKER_ID = p_worker_id and

Line 2385: PJI_FP_TXN_ACCUM bal,

2381: to_number(null) G2_OTH_COMMITTED_COST,
2382: bal.QUANTITY,
2383: bal.BILL_QUANTITY
2384: from
2385: PJI_FP_TXN_ACCUM bal,
2386: (
2387: select
2388: distinct
2389: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,

Line 2469: PJI_FP_TXN_ACCUM1 bal,

2465: bal.G2_OTH_COMMITTED_COST,
2466: to_number(null) QUANTITY,
2467: to_number(null) BILL_QUANTITY
2468: from
2469: PJI_FP_TXN_ACCUM1 bal,
2470: (
2471: select
2472: distinct
2473: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,

Line 2555: PJI_FP_TXN_ACCUM bal

2551: bal.BILL_QUANTITY
2552: from
2553: PJI_PA_PROJ_EVENTS_LOG log,
2554: PJI_PJP_PROJ_EXTR_STATUS stat,
2555: PJI_FP_TXN_ACCUM bal
2556: where
2557: p_extraction_type = 'RBS' and
2558: log.WORKER_ID = p_worker_id and
2559: log.EVENT_TYPE = 'RBS_PUSH' and

Line 2634: PJI_FP_TXN_ACCUM1 bal

2630: to_number(null) BILL_QUANTITY
2631: from
2632: PJI_PA_PROJ_EVENTS_LOG log,
2633: PJI_PJP_PROJ_EXTR_STATUS stat,
2634: PJI_FP_TXN_ACCUM1 bal
2635: where
2636: p_extraction_type = 'RBS' and
2637: log.WORKER_ID = p_worker_id and
2638: log.EVENT_TYPE = 'RBS_PUSH' and