APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PJI_FP_TXN_ACCUM

Line 23: MERGE INTO PJI_FP_TXN_ACCUM accum

19: p_project_id IN NUMBER
20: ) as
21:
22: begin
23: MERGE INTO PJI_FP_TXN_ACCUM accum
24: USING
25: ( SELECT
26: TXN_ACCUM_HEADER_ID,
27: RESOURCE_CLASS_ID,

Line 238: from PJI_FP_TXN_ACCUM1 bal

234:
235:
236:
237: delete
238: from PJI_FP_TXN_ACCUM1 bal
239: where bal.PROJECT_ID = p_project_id;
240:
241:
242: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i

Line 242: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i

238: from PJI_FP_TXN_ACCUM1 bal
239: where bal.PROJECT_ID = p_project_id;
240:
241:
242: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i
243: (
244: TXN_ACCUM_HEADER_ID,
245: PROJECT_ID,
246: PROJECT_ORG_ID,

Line 1185: FROM pji_fp_txn_accum tmp

1181: G1_BRDN_COST , G1_BILL_RAW_COST , G1_BILL_BRDN_COST ,
1182: G2_REVENUE , G2_RAW_COST , G2_BRDN_COST ,
1183: G2_BILL_RAW_COST , G2_BILL_BRDN_COST , ASSIGNMENT_ID ,
1184: p_worker_id , 'A' , NAMED_ROLE --Bug#4590810
1185: FROM pji_fp_txn_accum tmp
1186: ,pa_proj_fp_options ppfo
1187: WHERE
1188: tmp.PROJECT_ID= p_project_id AND
1189: ppfo.PROJECT_ID=tmp.PROJECT_ID AND