APPS.OKL_FUNDING_WF dependencies on OKL_TXL_AP_INV_LNS_ALL_B

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

378: FROM okl_trx_ap_invoices_b tap
379: WHERE tap.id = p_funding_id;
380:
381: --Added by dpsingh for LE uptake
382: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b as khr_id
383: -- now resides in this table. changes made as part of OKLR12B disbursements project
384: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
385: SELECT con.contract_number,con.id
386: FROM OKL_TRX_AP_INVOICES_B ap_inv

Line 388: ,okl_txl_ap_inv_lns_all_b tpl

384: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
385: SELECT con.contract_number,con.id
386: FROM OKL_TRX_AP_INVOICES_B ap_inv
387: ,OKC_K_HEADERS_B con
388: ,okl_txl_ap_inv_lns_all_b tpl
389: WHERE ap_inv.id = tpl.tap_id
390: AND tpl.khr_id = con.id
391: AND ap_inv.id = p_funding_id;
392:

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

749: FROM okc_k_headers_b chrb
750: WHERE chrb.id = p_creditline_id
751: ;
752:
753: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b
754: -- as references of khr_id is now moved to this table from okl_trx_ap_invoices_b
755: -- changes made as part of OKLR12B disbursments project
756: CURSOR c_funding_req(p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
757: IS

Line 771: okl_txl_ap_inv_lns_all_b tpl,

767: khr.id contract_id,
768: khr.contract_number,
769: party.name customer_name
770: FROM OKL_TRX_AP_INVS_ALL_B h,
771: okl_txl_ap_inv_lns_all_b tpl,
772: OKC_K_HEADERS_ALL_B khr,
773: PO_VENDORS v,
774: PO_VENDOR_SITES_ALL vs,
775: FND_LOOKUPS look1,