APPS.CSTPPACQ dependencies on MTL_PAC_TXN_COST_DETAILS

Line 1471: Delete from mtl_pac_txn_cost_details mptcd

1467:
1468: FOR c_rec IN c_lcm_adj(l_start_date,l_end_date) LOOP
1469: l_recs_processed := l_recs_processed + 1;
1470: l_stmt_num := 1100;
1471: Delete from mtl_pac_txn_cost_details mptcd
1472: where mptcd.transaction_id IN ( SELECT mmt.transaction_id
1473: FROM mtl_material_transactions mmt,
1474: cst_rcv_acq_costs_adj craca
1475: WHERE mmt.rcv_transaction_id

Line 2086: Insert into mtl_pac_txn_cost_details

2082: );
2083:
2084: /* insert into MPTCD */
2085: l_stmt_num := 1280;
2086: Insert into mtl_pac_txn_cost_details
2087: (cost_group_id,
2088: transaction_id,
2089: pac_period_id,
2090: cost_type_id,

Line 2325: Delete from mtl_pac_txn_cost_details mptcd

2321: -- Delete from MMT and MPTCD transactions that were created for the
2322: -- previous run for this receipt and then delete from craca and cracda*/
2323:
2324: l_stmt_num := 71;
2325: Delete from mtl_pac_txn_cost_details mptcd
2326: where mptcd.transaction_id IN ( select craca.mmt_transaction_id
2327: from cst_rcv_acq_costs_adj craca
2328: where craca.mmt_transaction_id is not null
2329: and craca.period_id = i_period

Line 4440: Insert into mtl_pac_txn_cost_details

4436: );
4437:
4438: /* insert into MPTCD */
4439:
4440: Insert into mtl_pac_txn_cost_details
4441: (cost_group_id,
4442: transaction_id,
4443: pac_period_id,
4444: cost_type_id,