DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on MTL_PAC_COST_SUBELEMENTS

Line 3188: from mtl_pac_cost_subelements

3184: l_stmt_num := 222;
3185:
3186: select sum(nvl(actual_cost,0))
3187: into l_mat_ovhd_cost
3188: from mtl_pac_cost_subelements
3189: where transaction_id = i_ae_txn_rec.transaction_id
3190: and cost_group_id = i_ae_txn_rec.cost_group_id
3191: and pac_period_id = i_ae_txn_rec.accounting_period_id
3192: and cost_type_id = i_ae_txn_rec.cost_type_id

Line 5455: from mtl_pac_cost_subelements

5451: l_stmt_num := 635;
5452:
5453: select sum(nvl(actual_cost,0))
5454: into l_mat_ovhd_cost
5455: from mtl_pac_cost_subelements
5456: where transaction_id = i_ae_txn_rec.transaction_id
5457: and cost_group_id = i_ae_txn_rec.cost_group_id
5458: and pac_period_id = i_ae_txn_rec.accounting_period_id
5459: and cost_type_id = i_ae_txn_rec.cost_type_id

Line 7595: from mtl_pac_cost_subelements

7591: process_error EXCEPTION;
7592:
7593: cursor mat_ovhds is
7594: select resource_id, actual_cost
7595: from mtl_pac_cost_subelements
7596: where transaction_id = i_ae_txn_rec.transaction_id
7597: and cost_group_id = i_ae_txn_rec.cost_group_id
7598: and pac_period_id = i_ae_txn_rec.accounting_period_id
7599: and cost_type_id = i_ae_txn_rec.cost_type_id