APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 840: from okc_k_party_roles_b

836:
837: CURSOR check_party_csr(p_chr_id NUMBER, p_rle_code VARCHAR2,p_id1 VARCHAR2, p_id2 VARCHAR2) IS
838: --Start modified abhsaxen for performance SQLID 20562561
839: select count(1)
840: from okc_k_party_roles_b
841: where dnz_chr_id = p_chr_id
842: and chr_id = p_chr_id
843: and rle_code = p_rle_code
844: and object1_id1 = p_id1

Line 1294: from okc_k_party_roles_b

1290:
1291: cursor l_line_csr(p_id1 varchar2) IS
1292: --Start modified abhsaxen for performance SQLID 20562568
1293: select count(*)
1294: from okc_k_party_roles_b
1295: where chr_id is null
1296: and cle_id is not null
1297: and rle_code = 'OKL_VENDOR'
1298: and dnz_chr_id = p_chr_id

Line 1523: -- okc_k_party_roles_b and okl_k_party_roles

1519:
1520: lp_cplv_rec.id := p_cpl_id;
1521: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
1522: -- to delete records in tables
1523: -- okc_k_party_roles_b and okl_k_party_roles
1524: /*
1525: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
1526: p_api_version => p_api_version,
1527: p_init_msg_list => p_init_msg_list,