APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKX_VENDOR_SITES_V

Line 1256: l_id1 okx_vendor_sites_v.vendor_id%type;

1252: row_count number;
1253:
1254: l_k_vendor_id1 okc_k_party_roles_v.object1_id1%type;
1255: l_rle_code okc_k_party_roles_v.rle_code%type;
1256: l_id1 okx_vendor_sites_v.vendor_id%type;
1257:
1258: l_id okc_rg_party_roles_v.id%type;
1259: l_rgp_id okc_rg_party_roles_v.rgp_id%type;
1260: l_rul_id okc_rules_v.id%type;

Line 1283: select count(*) from okx_vendor_sites_v

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

Line 1287: and a.ipvs_id = okx_vendor_sites_v.id1

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;
1290:
1291: cursor l_line_csr(p_id1 varchar2) IS