APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKL_TXL_RCPT_APPS_V

Line 370: FROM okl_trx_csh_receipt_v otcr, okl_txl_rcpt_apps_v otra

366: AND trx_status_code <> 'ERROR';
367:
368: Cursor Advance_receipt_csr(p_contract_id NUMBER) IS
369: SELECT '!'
370: FROM okl_trx_csh_receipt_v otcr, okl_txl_rcpt_apps_v otra
371: WHERE otcr.id = otra.rct_id_details
372: AND otcr.receipt_type = 'ADV'
373: AND otra.khr_id = p_contract_id;
374: