APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 37: FROM okc_k_party_roles_b

33: FUNCTION chk_party_Exists(p_chr_id IN NUMBER) return BOOLEAN IS
34:
35: CURSOR l_party_csr(p_chr_id NUMBER) IS
36: SELECT count(*)
37: FROM okc_k_party_roles_b
38: WHERE dnz_chr_id =p_chr_id
39: AND rle_code in ('CUSTOMER','SUBSCRIBER')
40: AND cle_id is null;
41: --AND chr_id is null;

Line 2334: FROM okc_k_party_roles_b

2330: WHERE cle_id = p_cle_id;
2331:
2332: CURSOR get_cpl(p_chr_id number) IS
2333: SELECT id
2334: FROM okc_k_party_roles_b
2335: WHERE dnz_chr_id = p_chr_id
2336: AND cle_id is not null
2337: AND rle_code in ('CUSTOMER','SUBSCRIBER');
2338: