DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on RCV_MC_REC_SUB_LEDGER

Line 2092: x_err_stage := ' Select from rcv_mc_rec_sub_ledger';

2088:
2089: l_old_stack := x_err_stack;
2090: x_err_code := 0;
2091: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_po_rate';
2092: x_err_stage := ' Select from rcv_mc_rec_sub_ledger';
2093:
2094: l_rcv_txn_id := to_number(x_rcv_txn_id);
2095:
2096: -- To get the porates logic used : FC:Foreign curr, PC:Pri Curr,Rep:Reporting

Line 2127: rcv_mc_rec_sub_ledger mcsub,

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
2130: WHERE rcvtxn.transaction_id = l_rcv_txn_id
2131: AND rcvtxn.po_distribution_id = x_po_dist_id

Line 2166: rcv_mc_rec_sub_ledger mcsub,

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
2169: WHERE rcvtxn.transaction_id = l_rcv_txn_id
2170: AND rcvtxn.po_distribution_id = x_po_dist_id