APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKC_CONTACTS

Line 377: FROM OKC_CONTACTS

373: IS
374:
375: CURSOR l_contact_csr IS
376: SELECT ID
377: FROM OKC_CONTACTS
378: WHERE DNZ_CHR_ID = p_dnz_chr_id
379: AND CPL_ID = P_CPL_Id;
380:
381: l_cle_id Number;

Line 405: FROM OKC_CONTACTS

401: IS
402:
403: CURSOR l_contact_csr IS
404: SELECT ID
405: FROM OKC_CONTACTS
406: WHERE DNZ_CHR_ID = p_dnz_chr_id
407: AND CPL_ID = P_CPL_Id
408: AND JTOT_OBJECT1_CODE =p_jtot_code
409: AND cro_code =p_cro_code ;

Line 565: -- select * from okc_contacts

561: from okc_k_lines_b
562: where id =p_cle_id;
563: --commenting out, because it is not beeing used any where, 05/04/2004
564: --Cursor line_contact(p_contact_id in number ) IS
565: -- select * from okc_contacts
566: -- where id = p_contact_id;
567: -- line_contact_rec line_contact%rowtype;
568:
569:

Line 711: select * from okc_contacts

707:
708:
709:
710: Cursor line_contact_jtot(p_cpl_id in number,p_chr_id IN NUMBER, p_jtot_object_code IN VARCHAR2) IS
711: select * from okc_contacts
712: where cpl_id = p_cpl_id
713: AND JTOT_OBJECT1_CODE <> p_jtot_object_code
714: AND DNZ_CHR_ID = p_chr_id;
715: