APPS.ARP_CONFIRMATION dependencies on RA_CUSTOMER_TRX_ALL

Line 612: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;

608:
609: -- Following two parametes and the currency cursor is introduced By
610: -- RAM-C (ORASHID)
611:
612: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
613: l_invoice_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
614:
615: CURSOR currency (p_trx_id IN NUMBER) IS
616: SELECT invoice_currency_code,

Line 613: l_invoice_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

609: -- Following two parametes and the currency cursor is introduced By
610: -- RAM-C (ORASHID)
611:
612: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
613: l_invoice_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
614:
615: CURSOR currency (p_trx_id IN NUMBER) IS
616: SELECT invoice_currency_code,
617: exchange_rate

Line 618: FROM ra_customer_trx_all

614:
615: CURSOR currency (p_trx_id IN NUMBER) IS
616: SELECT invoice_currency_code,
617: exchange_rate
618: FROM ra_customer_trx_all
619: WHERE customer_trx_id = p_trx_id;
620:
621:
622: -- Define cursor for applications:

Line 837: -- from ra_customer_trx_all given the customer_trx_id

833:
834: -- RAM-C changes begin.
835: --
836: -- get the invoice currency and the exchange rate
837: -- from ra_customer_trx_all given the customer_trx_id
838:
839: OPEN currency(l_ra_rec.applied_customer_trx_id);
840: FETCH currency INTO l_invoice_currency_code, l_exchange_rate;
841: CLOSE currency;