APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKL_TXL_AP_INV_LNS_ALL_B

Line 1279: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and khr_id

1275: cursor l_vendor_csr is
1276: select object1_id1,rle_code from okc_k_party_roles_v
1277: where id = p_cpl_id;
1278:
1279: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and khr_id
1280: -- be referred from this table instead of okl_trx_ap_invoices_b. changes made
1281: -- as part of OKLR12B disbursements project
1282: cursor l_funding_chk_csr(p_id1 varchar2) IS
1283: select count(*) from okx_vendor_sites_v

Line 1285: ,okl_txl_ap_inv_lns_all_b b

1281: -- as part of OKLR12B disbursements project
1282: cursor l_funding_chk_csr(p_id1 varchar2) IS
1283: select count(*) from okx_vendor_sites_v
1284: where exists (select 1 from okl_trx_ap_invoices_b a
1285: ,okl_txl_ap_inv_lns_all_b b
1286: where a.id = b.tap_id
1287: and a.ipvs_id = okx_vendor_sites_v.id1
1288: and b.khr_id = p_chr_id)
1289: and vendor_id = p_id1;