DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on RCV_TRANSACTIONS

Line 1800: FROM rcv_transactions a

1796: l_rcv_txn_id := to_number(p_system_reference4);
1797:
1798: SELECT nvl(a.currency_conversion_date,a.transaction_date)
1799: INTO l_exchange_date
1800: FROM rcv_transactions a
1801: WHERE a.po_distribution_id = p_system_reference3
1802: AND a.transaction_id = l_rcv_txn_id;
1803:
1804: END IF;

Line 2125: FROM rcv_transactions rcvtxn,

2121: INTO x_exchange_rate,
2122: x_exchange_date,
2123: x_exchange_rate_type,
2124: x_amount
2125: FROM rcv_transactions rcvtxn,
2126: rcv_receiving_sub_ledger rcvsub,
2127: rcv_mc_rec_sub_ledger mcsub,
2128: rcv_mc_transactions mctxn,
2129: po_distributions po_dist

Line 2164: FROM rcv_transactions rcvtxn,

2160: INTO x_exchange_rate,
2161: x_exchange_date,
2162: x_exchange_rate_type,
2163: x_amount
2164: FROM rcv_transactions rcvtxn,
2165: rcv_receiving_sub_ledger rcvsub,
2166: rcv_mc_rec_sub_ledger mcsub,
2167: rcv_mc_transactions mctxn,
2168: po_distributions po_dist