DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKL_TRX_AP_INVOICES_B

Line 1280: -- be referred from this table instead of okl_trx_ap_invoices_b. changes made

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
1284: where exists (select 1 from okl_trx_ap_invoices_b a

Line 1284: where exists (select 1 from okl_trx_ap_invoices_b a

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
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)