APPS.CSTPAPBR dependencies on MTL_PAC_TXN_COST_DETAILS

Line 2598: FROM mtl_pac_txn_cost_details

2594: l_stmt_num := 80;
2595:
2596: SELECT sum(nvl(transaction_cost,0))
2597: INTO l_mptcd_cost
2598: FROM mtl_pac_txn_cost_details
2599: WHERE transaction_id = i_ae_txn_rec.transaction_id
2600: AND pac_period_id = i_ae_txn_rec.accounting_period_id
2601: AND cost_group_id = i_ae_txn_rec.cost_group_id;
2602:

Line 3484: FROM mtl_pac_txn_cost_details

3480: l_stmt_num := 224;
3481:
3482: SELECT sum(nvl(transaction_cost,0))
3483: INTO l_mptcd_cost
3484: FROM mtl_pac_txn_cost_details
3485: WHERE transaction_id = i_ae_txn_rec.transaction_id
3486: AND pac_period_id = i_ae_txn_rec.accounting_period_id
3487: AND cost_group_id = i_ae_txn_rec.cost_group_id;
3488:

Line 4566: FROM mtl_pac_txn_cost_details

4562: l_stmt_num := 412;
4563:
4564: SELECT sum(nvl(transaction_cost,0))
4565: INTO l_mptcd_cost
4566: FROM mtl_pac_txn_cost_details
4567: WHERE transaction_id = i_ae_txn_rec.transaction_id
4568: AND pac_period_id = i_ae_txn_rec.accounting_period_id
4569: AND cost_group_id = i_ae_txn_rec.cost_group_id;
4570:

Line 4820: FROM mtl_pac_txn_cost_details

4816: l_stmt_num := 435;
4817:
4818: SELECT sum(nvl(transaction_cost,0))
4819: INTO l_mptcd_cost
4820: FROM mtl_pac_txn_cost_details
4821: WHERE transaction_id = i_ae_txn_rec.transaction_id
4822: AND pac_period_id = i_ae_txn_rec.accounting_period_id
4823: AND cost_group_id = i_ae_txn_rec.cost_group_id;
4824:

Line 5567: FROM mtl_pac_txn_cost_details

5563:
5564:
5565: SELECT sum(nvl(transaction_cost,0))
5566: INTO l_mptcd_cost
5567: FROM mtl_pac_txn_cost_details
5568: WHERE transaction_id = i_ae_txn_rec.transaction_id
5569: AND pac_period_id = i_ae_txn_rec.accounting_period_id
5570: AND cost_group_id = i_ae_txn_rec.cost_group_id;
5571:

Line 6102: from mtl_pac_txn_cost_details mptcd

6098: -- -----------------------------------------------
6099: l_stmt_num := 30;
6100: select count (1)
6101: into l_value_change_flag
6102: from mtl_pac_txn_cost_details mptcd
6103: where mptcd.transaction_id = i_ae_txn_rec.transaction_id
6104: and mptcd.pac_period_id = i_ae_txn_rec.accounting_period_id
6105: and mptcd.cost_group_id = i_ae_txn_rec.cost_group_id
6106: and mptcd.value_change is not null