APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 774: FROM ra_customer_trx_all

770:
771: -- Cursor to get the AR invoice Numbers for log file
772: CURSOR ar_inv_csr ( p_receivables_invoice_id NUMBER ) IS
773: SELECT trx_number
774: FROM ra_customer_trx_all
775: WHERE CUSTOMER_TRX_ID = p_receivables_invoice_id;
776:
777: --cursor to get the receipt applications applied to a invoice
778: CURSOR l_receipt_applic_csr(cp_customer_trx_id NUMBER) IS

Line 796: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;

792: AND PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
793:
794:
795: --Local Variables
796: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
797: l_try_id okl_trx_ap_invoices_b.try_id%TYPE;
798: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
799: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
800: