DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on MTL_PAC_COST_SUBELEMENTS

Line 3470: from mtl_pac_cost_subelements

3466: l_stmt_num := 222;
3467:
3468: select sum(nvl(actual_cost,0))
3469: into l_mat_ovhd_cost
3470: from mtl_pac_cost_subelements
3471: where transaction_id = i_ae_txn_rec.transaction_id
3472: and cost_group_id = i_ae_txn_rec.cost_group_id
3473: and pac_period_id = i_ae_txn_rec.accounting_period_id
3474: and cost_type_id = i_ae_txn_rec.cost_type_id

Line 5737: from mtl_pac_cost_subelements

5733: l_stmt_num := 635;
5734:
5735: select sum(nvl(actual_cost,0))
5736: into l_mat_ovhd_cost
5737: from mtl_pac_cost_subelements
5738: where transaction_id = i_ae_txn_rec.transaction_id
5739: and cost_group_id = i_ae_txn_rec.cost_group_id
5740: and pac_period_id = i_ae_txn_rec.accounting_period_id
5741: and cost_type_id = i_ae_txn_rec.cost_type_id

Line 7978: from mtl_pac_cost_subelements

7974: process_error EXCEPTION;
7975:
7976: cursor mat_ovhds is
7977: select resource_id, actual_cost
7978: from mtl_pac_cost_subelements
7979: where transaction_id = i_ae_txn_rec.transaction_id
7980: and cost_group_id = i_ae_txn_rec.cost_group_id
7981: and pac_period_id = i_ae_txn_rec.accounting_period_id
7982: and cost_type_id = i_ae_txn_rec.cost_type_id