DBA Data[Home] [Help]

APPS.OKC_QA_GENERAL_CHECKLISTS dependencies on OKC_CONTACTS

Line 161: from okc_contacts c, okc_k_party_roles_b p

157: */
158:
159: cursor csr_contacts is
160: select c.jtot_object1_code, c.object1_id1, c.object1_id2
161: from okc_contacts c, okc_k_party_roles_b p
162: where c.cpl_id = p.id
163: and p.dnz_chr_id = p_chr_id
164: and p.cle_id is null;
165:

Line 273: from okc_contacts c

269:
270:
271: cursor csr_contacts(p_cpl_id Number) is
272: select c.jtot_object1_code, c.object1_id1, c.object1_id2
273: from okc_contacts c
274: where c.cpl_id = p_cpl_id
275: and c.dnz_chr_id = p_chr_id;
276:
277: cursor csr_rle is

Line 286: from okc_contacts c, okc_k_party_roles_b p

282: and cle_id is null;
283:
284: /* cursor csr_con_exist is
285: select 'X'
286: from okc_contacts c, okc_k_party_roles_b p
287: where p.id = c.cpl_id
288: and p.dnz_chr_id = p_chr_id
289: and p.rle_code = p_rle_code; */
290: