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 4856: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b

4852: --should be an outer join with party roles, so that
4853: --if we don't get a vendor/merchant party we atleast get an org
4854: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
4855: SELECT nvl(a.org_id, a.authoring_org_id), b.id
4856: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b
4857: ON a.id = b.dnz_chr_id
4858: AND b.cle_id IS NULL
4859: AND b.rle_code IN ('VENDOR', 'MERCHANT')
4860: WHERE a.id = cp_chr_id;

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

4904: FND_MSG_PUB.initialize;
4905: END IF;
4906: x_return_status := FND_API.G_RET_STS_SUCCESS;
4907:
4908: --first get the contract org and id for the merchant/vendor record in okc_k_party_roles_b
4909: OPEN c_k_hdr(p_chr_id);
4910: FETCH c_k_hdr INTO l_org_id, l_cpl_id;
4911: CLOSE c_k_hdr;
4912: