[Home] [Help]
755: p_mode IN VARCHAR2) IS
756:
757: CURSOR check_upd_le_fund_csr (p_khr_id NUMBER) IS
758: SELECT 1
759: FROM OKL_TRX_AP_INVOICES_B
760: WHERE KHR_ID = p_khr_id
761: AND FUNDING_TYPE_CODE IS NOT NULL
762: AND TRX_STATUS_CODE <> 'CANCELED';
763:
6871: and mla.scs_code = 'MASTER_LEASE';
6872:
6873: cursor is_k_fund_aprvd_csr is
6874: select 'Y'
6875: from okl_trx_ap_invoices_b ap
6876: where ap.khr_id = p_chr_id
6877: and ap.funding_type_code is not null
6878: and ap.trx_status_code in ('APPROVED', 'PROCESSED');
6879: