APPS.OKL_CONTRACT_PVT dependencies on OKL_TXL_AP_INV_LNS_ALL_B

Line 4649: -- sjalasut, added okl_txl_ap_inv_lns_all_b as part of OKLR12B disbursements project

4645: end if;
4646:
4647: -- Check if funding txn exists
4648: l_funding_count := 0;
4649: -- sjalasut, added okl_txl_ap_inv_lns_all_b as part of OKLR12B disbursements project
4650: -- also changed the reference of okl_trx_ap_invoices_v to okl_trx_ap_invoices_b
4651: select count(1) into l_funding_count
4652: from okl_trx_ap_invoices_b a
4653: ,okl_txl_ap_inv_lns_all_b b

Line 4653: ,okl_txl_ap_inv_lns_all_b b

4649: -- sjalasut, added okl_txl_ap_inv_lns_all_b as part of OKLR12B disbursements project
4650: -- also changed the reference of okl_trx_ap_invoices_v to okl_trx_ap_invoices_b
4651: select count(1) into l_funding_count
4652: from okl_trx_ap_invoices_b a
4653: ,okl_txl_ap_inv_lns_all_b b
4654: where a.id = b.tap_id
4655: and b.khr_id = p_contract_id
4656: and a.funding_type_code is not null
4657: and rownum < 2;