APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 775: FROM OKL_TRX_AP_INVOICES_B

771: p_mode IN VARCHAR2) IS
772:
773: CURSOR check_upd_le_fund_csr (p_khr_id NUMBER) IS
774: SELECT 1
775: FROM OKL_TRX_AP_INVOICES_B
776: WHERE KHR_ID = p_khr_id
777: AND FUNDING_TYPE_CODE IS NOT NULL
778: AND TRX_STATUS_CODE <> 'CANCELED';
779:

Line 6891: from okl_trx_ap_invoices_b ap

6887: and mla.scs_code = 'MASTER_LEASE';
6888:
6889: cursor is_k_fund_aprvd_csr is
6890: select 'Y'
6891: from okl_trx_ap_invoices_b ap
6892: where ap.khr_id = p_chr_id
6893: and ap.funding_type_code is not null
6894: and ap.trx_status_code in ('APPROVED', 'PROCESSED');
6895: