APPS.OKL_RELEASE_PVT dependencies on OKL_TRX_TYPES_B
Line 2440: okl_trx_types_b typ
2436: -- Cursor for obtaining the last credit memo date
2437: CURSOR last_credit_date_csr(p_contract_id IN NUMBER) IS
2438: SELECT max(date_invoiced)
2439: FROM okl_trx_ar_invoices_b tar, 2440: okl_trx_types_b typ 2441: WHERE tar.khr_id = p_contract_id
2442: AND tar.amount<0
2443: AND tar.try_id = typ.id
2444: AND typ.aep_code = 'CREDIT_MEMO';