DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 962: pa_transaction_interface_all txn

958: x_exchange_rate,
959: x_exchange_date,
960: x_exchange_rate_type
961: FROM pa_mc_txn_interface_all mc,
962: pa_transaction_interface_all txn
963: WHERE mc.txn_interface_id = txn.txn_interface_id
964: AND txn.expenditure_item_id = x_exp_item_id
965: AND mc.set_of_books_id = x_set_of_books_id;
966:

Line 1654: from pa_transaction_interface_all

1650: l_txn_raw_cost,
1651: --removed l_exchange_rate_type,
1652: --removed l_exchange_rate,
1653: l_currency
1654: from pa_transaction_interface_all
1655: where interface_id = p_interface_id
1656: and cdl_system_reference1 = to_char(p_system_reference1)
1657: and cdl_system_reference2 = to_char(p_system_reference2)
1658: and cdl_system_reference3 = to_char(p_system_reference3)

Line 1676: from pa_transaction_interface_all

1672: into l_txn_interface_id,
1673: l_burdened_cost,
1674: l_txn_raw_cost,
1675: l_currency
1676: from pa_transaction_interface_all
1677: where interface_id = p_interface_id
1678: and cdl_system_reference1 = to_char(p_system_reference1)
1679: and cdl_system_reference2 = to_char(p_system_reference2)
1680: and cdl_system_reference3 = to_char(p_system_reference3)