APPS.OKL_CONTRACT_PARTY_PVT dependencies on OKC_CONTACTS

Line 28: FROM okc_contacts

24: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
25:
26: CURSOR cur_ctcv IS
27: SELECT 'x'
28: FROM okc_contacts
29: WHERE cpl_id = p_ctcv_rec.CPL_ID
30: AND cro_code = p_ctcv_rec.CRO_CODE
31: AND NVL(jtot_object1_code,'X') = NVL(p_ctcv_rec.JTOT_OBJECT1_CODE,'X')
32: AND NVL(object1_id1,'X') = NVL(p_ctcv_rec.OBJECT1_ID1,'X')

Line 283: l_dnz_chr_id OKC_CONTACTS.DNZ_CHR_ID%TYPE;

279: p_ctcv_rec IN ctcv_rec_type) IS
280: l_api_name CONSTANT VARCHAR2(30) := 'delete_contact';
281: l_api_version CONSTANT NUMBER := 1;
282: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
283: l_dnz_chr_id OKC_CONTACTS.DNZ_CHR_ID%TYPE;
284:
285: CURSOR cur_get_dnz_chr_id IS
286: SELECT dnz_chr_id
287: FROM okc_contacts

Line 287: FROM okc_contacts

283: l_dnz_chr_id OKC_CONTACTS.DNZ_CHR_ID%TYPE;
284:
285: CURSOR cur_get_dnz_chr_id IS
286: SELECT dnz_chr_id
287: FROM okc_contacts
288: WHERE id = p_ctcv_rec.id;
289:
290: BEGIN
291: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name

Line 694: FROM OKC_CONTACTS_V

690: l_dnz_chr_id okc_k_party_roles_v.dnz_chr_id%TYPE;
691:
692: CURSOR l_cpl_csr IS
693: SELECT 'x'
694: FROM OKC_CONTACTS_V
695: WHERE CPL_ID = p_cplv_rec.id;
696:
697: CURSOR l_rle_code_csr IS
698: SELECT rle_code