APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 1331: FROM okc_k_headers_all_b a, okc_k_party_roles_b b

1327:
1328: --gets the contract org id and customer/subscriber party id
1329: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
1330: SELECT nvl(a.org_id, a.authoring_org_id), to_number(b.object1_id1)
1331: FROM okc_k_headers_all_b a, okc_k_party_roles_b b
1332: WHERE a.id = cp_chr_id
1333: AND b.rle_code IN ('CUSTOMER', 'SUBSCRIBER')
1334: AND b.dnz_chr_id = a.id
1335: AND b.cle_id IS NULL;

Line 1358: --gets the contract vendor/merhcant record id, rle_code from okc_k_party_roles_b

1354: FROM hr_all_organization_units hr
1355: WHERE hr.organization_id = cp_org_id;
1356:
1357:
1358: --gets the contract vendor/merhcant record id, rle_code from okc_k_party_roles_b
1359: CURSOR c_get_ven_mer_id(cp_chr_id IN NUMBER) IS
1360: SELECT id, rle_code
1361: FROM okc_k_party_roles_b
1362: WHERE dnz_chr_id = cp_chr_id AND cle_id IS NULL

Line 1361: FROM okc_k_party_roles_b

1357:
1358: --gets the contract vendor/merhcant record id, rle_code from okc_k_party_roles_b
1359: CURSOR c_get_ven_mer_id(cp_chr_id IN NUMBER) IS
1360: SELECT id, rle_code
1361: FROM okc_k_party_roles_b
1362: WHERE dnz_chr_id = cp_chr_id AND cle_id IS NULL
1363: AND rle_code IN ('VENDOR', 'MERCHANT');
1364:
1365: --gets the cro_code for vendor/merchant contact source based on OKX_SALEPERS

Line 4821: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b

4817: --should be an outer join with party roles, so that
4818: --if we don't get a vendor/merchant party we atleast get an org
4819: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
4820: SELECT nvl(a.org_id, a.authoring_org_id), b.id
4821: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b
4822: ON a.id = b.dnz_chr_id
4823: AND b.cle_id IS NULL
4824: AND b.rle_code IN ('VENDOR', 'MERCHANT')
4825: WHERE a.id = cp_chr_id;

Line 4873: --first get the contract org and id for the merchant/vendor record in okc_k_party_roles_b

4869: FND_MSG_PUB.initialize;
4870: END IF;
4871: x_return_status := FND_API.G_RET_STS_SUCCESS;
4872:
4873: --first get the contract org and id for the merchant/vendor record in okc_k_party_roles_b
4874: OPEN c_k_hdr(p_chr_id);
4875: FETCH c_k_hdr INTO l_org_id, l_cpl_id;
4876: CLOSE c_k_hdr;
4877: