APPS.OKS_COC_PVT dependencies on OKC_CONTACT_SOURCES_V

Line 314: SELECT count(1) FROM Okc_Contact_Sources_v ocs,

310: Is
311: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
312: l_Count INTEGER;
313: CURSOR cro_Cur IS
314: SELECT count(1) FROM Okc_Contact_Sources_v ocs,
315: fnd_lookups fl
316: WHERE ocs.CRO_CODE=p_cocv_Rec.Cro_Code
317: and ocs.buy_or_sell='S'
318: and fl.lookup_type='OKC_CONTACT_ROLE'

Line 367: okc_CONTACT_SOURCES_V RS

363: --
364: cursor l_object_csr is
365: select '!'
366: from
367: okc_CONTACT_SOURCES_V RS
368: where
369: RS.rle_code IN ('VENDOR','CUSTOMER')
370: and RS.jtot_object_code = p_cocv_rec.jtot_object_code
371: and sysdate >= RS.start_date