APPS.OKL_FUNDING_WF dependencies on OKL_TXL_AP_INV_LNS_ALL_B

Line 355: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b as khr_id

351: FROM okl_trx_ap_invoices_b tap
352: WHERE tap.id = p_funding_id;
353:
354: --Added by dpsingh for LE uptake
355: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b as khr_id
356: -- now resides in this table. changes made as part of OKLR12B disbursements project
357: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
358: SELECT con.contract_number,con.id
359: FROM OKL_TRX_AP_INVOICES_B ap_inv

Line 361: ,okl_txl_ap_inv_lns_all_b tpl

357: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
358: SELECT con.contract_number,con.id
359: FROM OKL_TRX_AP_INVOICES_B ap_inv
360: ,OKC_K_HEADERS_B con
361: ,okl_txl_ap_inv_lns_all_b tpl
362: WHERE ap_inv.id = tpl.tap_id
363: AND tpl.khr_id = con.id
364: AND ap_inv.id = p_funding_id;
365:

Line 711: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b

707: FROM okc_k_headers_b chrb
708: WHERE chrb.id = p_creditline_id
709: ;
710:
711: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b
712: -- as references of khr_id is now moved to this table from okl_trx_ap_invoices_b
713: -- changes made as part of OKLR12B disbursments project
714: CURSOR c_funding_req(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
715: IS

Line 729: okl_txl_ap_inv_lns_all_b tpl,

725: khr.id contract_id,
726: khr.contract_number,
727: party.name customer_name
728: FROM OKL_TRX_AP_INVS_ALL_B h,
729: okl_txl_ap_inv_lns_all_b tpl,
730: OKC_K_HEADERS_ALL_B khr,
731: PO_VENDORS v,
732: PO_VENDOR_SITES_ALL vs,
733: FND_LOOKUPS look1,