APPS.OKS_RENEW_UTIL_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 432: SELECT object1_id1 FROM okc_k_party_roles_b

428: l_effective_base_currency VARCHAR2(30);
429: l_error_text VARCHAR2(512);
430:
431: CURSOR c_k_party(cp_chr_id IN NUMBER) IS
432: SELECT object1_id1 FROM okc_k_party_roles_b
433: WHERE dnz_chr_id = cp_chr_id
434: AND cle_id IS NULL
435: AND jtot_object1_code = 'OKX_PARTY'
436: AND rle_code IN ('CUSTOMER', 'SUBSCRIBER');

Line 801: -- if contract party id is not passed get it from okc_k_party_roles_b

797:
798: --get the contract party, org and the contract level rules if p_chr_id is passed
799: IF(p_chr_id IS NOT NULL) THEN
800:
801: -- if contract party id is not passed get it from okc_k_party_roles_b
802: IF (l_party_id IS NULL) THEN
803: OPEN c_k_party(p_chr_id);
804: FETCH c_k_party INTO l_party_id;
805: CLOSE c_k_party;

Line 1037: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b

1033: --should be outer join with party roles, so that
1034: --if we don't get a party we atleast get an org
1035: CURSOR c_k_party_org(cp_chr_id IN NUMBER) IS
1036: SELECT b.object1_id1, a.authoring_org_id
1037: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b
1038: ON a.id = b.dnz_chr_id AND b.cle_id IS NULL AND b.jtot_object1_code = 'OKX_PARTY'
1039: AND b.rle_code IN ('CUSTOMER', 'SUBSCRIBER')
1040: WHERE a.id = cp_chr_id;
1041: