DBA Data[Home] [Help]

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';