APPS.CSTPPINV dependencies on MTL_PAC_ACTUAL_COST_DETAILS

Line 372: mtl_pac_actual_cost_details MPACD

368: /* Added for bug 9146453*/
369: SELECT count(*)
370: INTO l_already_processed
371: FROM mtl_material_transactions MMT,
372: mtl_pac_actual_cost_details MPACD
373: WHERE (MMT.transaction_action_id = 1 OR MMT.transaction_action_id = 7)
374: AND MMT.transaction_source_type_id = 2
375: AND EXISTS (SELECT 1
376: FROM cst_cost_group_assignments CCGA

Line 424: mtl_pac_actual_cost_details MPACD

420: i_prog_id,
421: SYSDATE,
422: i_login_id
423: FROM mtl_material_transactions MMT,
424: mtl_pac_actual_cost_details MPACD
425: WHERE (MMT.transaction_action_id = 1 OR MMT.transaction_action_id = 7)
426: AND MMT.transaction_source_type_id = 2
427: /* Bug 8236035
428: AND MMT.organization_id = i_txn_org_id*/

Line 2514: INSERT INTO mtl_pac_actual_cost_details (

2510:
2511: /* insert into mpacd */
2512: l_stmt_num := 40;
2513:
2514: INSERT INTO mtl_pac_actual_cost_details (
2515: transaction_id,
2516: pac_period_id,
2517: cost_type_id,
2518: cost_group_id,

Line 2569: FROM mtl_pac_actual_cost_details

2565: new_make_cost,
2566: insertion_flag,
2567: user_entered,
2568: sysdate
2569: FROM mtl_pac_actual_cost_details
2570: WHERE transaction_id = l_parent_transaction_id
2571: AND pac_period_id = i_pac_period_id
2572: AND cost_group_id = i_cost_group_id;
2573:

Line 2576: Delete from mtl_pac_actual_cost_details

2572: AND cost_group_id = i_cost_group_id;
2573:
2574: /* Delete the MPACD row of the parent */
2575:
2576: Delete from mtl_pac_actual_cost_details
2577: where transaction_id = l_parent_transaction_id
2578: AND pac_period_id = i_pac_period_id
2579: AND cost_group_id = i_cost_group_id;
2580:

Line 2646: INSERT INTO mtl_pac_actual_cost_details (

2642: mpacd */
2643:
2644: l_stmt_num := 70;
2645:
2646: INSERT INTO mtl_pac_actual_cost_details (
2647: transaction_id,
2648: pac_period_id,
2649: cost_type_id,
2650: cost_group_id,