APPS.ARP_CONFIRMATION dependencies on RA_CUSTOMER_TRX_ALL

Line 629: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;

625:
626: -- Following two parametes and the currency cursor is introduced By
627: -- RAM-C (ORASHID)
628:
629: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
630: l_invoice_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
631:
632: CURSOR currency (p_trx_id IN NUMBER) IS
633: SELECT invoice_currency_code,

Line 630: l_invoice_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

626: -- Following two parametes and the currency cursor is introduced By
627: -- RAM-C (ORASHID)
628:
629: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
630: l_invoice_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
631:
632: CURSOR currency (p_trx_id IN NUMBER) IS
633: SELECT invoice_currency_code,
634: exchange_rate

Line 635: FROM ra_customer_trx_all

631:
632: CURSOR currency (p_trx_id IN NUMBER) IS
633: SELECT invoice_currency_code,
634: exchange_rate
635: FROM ra_customer_trx_all
636: WHERE customer_trx_id = p_trx_id;
637:
638:
639: -- Define cursor for applications:

Line 854: -- from ra_customer_trx_all given the customer_trx_id

850:
851: -- RAM-C changes begin.
852: --
853: -- get the invoice currency and the exchange rate
854: -- from ra_customer_trx_all given the customer_trx_id
855:
856: OPEN currency(l_ra_rec.applied_customer_trx_id);
857: FETCH currency INTO l_invoice_currency_code, l_exchange_rate;
858: CLOSE currency;