117: from OKL_CNSLD_AR_HDRS_ALL_B
118: WHERE id = p_debit_doc_id
119: UNION
120: SELECT INVOICE_CURRENCY_CODE
121: FROM RA_CUSTOMER_TRX_ALL
122: WHERE CUSTOMER_TRX_ID = p_debit_doc_id;
123: --AKRANGAN ADDED FOR BATCH RECEIPTS CROSS CURR FUNCTIONALITY END
124:
125: -- retrieve all receipts for each batch at status 'SUBMITTED'
928: from OKL_CNSLD_AR_HDRS_ALL_B
929: WHERE id = p_debit_doc_id
930: UNION
931: SELECT INVOICE_CURRENCY_CODE
932: FROM RA_CUSTOMER_TRX_ALL
933: WHERE CUSTOMER_TRX_ID = p_debit_doc_id;
934: --NEW LOCAL VARIABLES ADDED FOR PROVIDING CROSS CURR FUNCTIONALITY
935: l_receipt_currency VARCHAR2(100);
936: l_invoice_currency_code VARCHAR2(100);