DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 819: FROM ra_customer_trx_all

815:
816: -- Cursor to get the AR invoice Numbers for log file
817: CURSOR ar_inv_csr ( p_receivables_invoice_id NUMBER ) IS
818: SELECT trx_number
819: FROM ra_customer_trx_all
820: WHERE CUSTOMER_TRX_ID = p_receivables_invoice_id;
821:
822: --cursor to get the receipt applications applied to a invoice
823: CURSOR l_receipt_applic_csr(cp_customer_trx_id NUMBER) IS

Line 841: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;

837: AND PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
838:
839:
840: --Local Variables
841: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
842: l_try_id okl_trx_ap_invoices_b.try_id%TYPE;
843: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
844: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
845: