DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on OKC_CONTACTS

Line 330: , okc_contacts oc2

326:
327: Cursor l_bill_contact_csr Is
328: Select Decode(SUBSTR (hz.person_last_name || ','|| hz.person_first_name, 1,255),',',null,SUBSTR (hz.person_last_name || ', '|| hz.person_first_name, 1,255)) Billing_contact
329: From hz_parties hz
330: , okc_contacts oc2
331: ,hz_relationships hr
332: Where oc2.jtot_object1_code = 'OKX_PCONTACT'
333: And oc2.cro_code = 'BILLING'
334: AND oc2.dnz_chr_id = p_contract_id

Line 364: , okc_contacts oc1

360: Cursor l_salesrep_csr Is
361: Select v.resource_name sales_person
362: From jtf_rs_salesreps jtf
363: , jtf_rs_resource_extns_vl v
364: , okc_contacts oc1
365: ,Okc_k_headers_all_b kh
366:
367: Where oc1.dnz_chr_id = P_contract_id
368: And Kh.id = oc1.dnz_chr_id