APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKL_TRX_CSH_RECEIPT_V

Line 74: FROM okl_trx_csh_receipt_v otcr, okl_txl_rcpt_apps_v otra

70: AND trx_status_code <> 'ERROR';
71:
72: Cursor Advance_receipt_csr(p_contract_id NUMBER) IS
73: SELECT '!'
74: FROM okl_trx_csh_receipt_v otcr, okl_txl_rcpt_apps_v otra
75: WHERE otcr.id = otra.rct_id_details
76: AND otcr.receipt_type = 'ADV'
77: AND otra.khr_id = p_contract_id;
78: