[Home] [Help]
2412: -- Cursor for obtaining the last credit memo date
2413: CURSOR last_credit_date_csr(p_contract_id IN NUMBER) IS
2414: SELECT max(date_invoiced)
2415: FROM okl_trx_ar_invoices_b tar,
2416: okl_trx_types_b typ
2417: WHERE tar.khr_id = p_contract_id
2418: AND tar.amount<0
2419: AND tar.try_id = typ.id
2420: AND typ.aep_code = 'CREDIT_MEMO';