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 2343: FROM okc_k_party_roles_b

2339: WHERE cle_id = p_cle_id;
2340:
2341: CURSOR get_cpl(p_chr_id number) IS
2342: SELECT id
2343: FROM okc_k_party_roles_b
2344: WHERE dnz_chr_id = p_chr_id
2345: AND cle_id is not null
2346: AND rle_code in ('CUSTOMER','SUBSCRIBER');
2347: