DBA Data[Home] [Help]

APPS.OKS_COC_PVT dependencies on FND_LOOKUPS

Line 315: fnd_lookups fl

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'
319: and ocs.jtot_object_code='OKX_PCONTACT'