DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 4735: -- also changed the reference of okl_trx_ap_invoices_v to okl_trx_ap_invoices_b

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

Line 4737: from okl_trx_ap_invoices_b a

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