4731:
4732: -- Check if funding txn exists
4733: l_funding_count := 0;
4734: -- sjalasut, added okl_txl_ap_inv_lns_all_b as part of OKLR12B disbursements project
4735: -- also changed the reference of okl_trx_ap_invoices_v to okl_trx_ap_invoices_b
4736: select count(1) into l_funding_count
4737: from okl_trx_ap_invoices_b a
4738: ,okl_txl_ap_inv_lns_all_b b
4739: where a.id = b.tap_id
4733: l_funding_count := 0;
4734: -- sjalasut, added okl_txl_ap_inv_lns_all_b as part of OKLR12B disbursements project
4735: -- also changed the reference of okl_trx_ap_invoices_v to okl_trx_ap_invoices_b
4736: select count(1) into l_funding_count
4737: from okl_trx_ap_invoices_b a
4738: ,okl_txl_ap_inv_lns_all_b b
4739: where a.id = b.tap_id
4740: and b.khr_id = p_contract_id
4741: and a.funding_type_code is not null