DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on PO_VENDOR_SITES_ALL

Line 7532: PO_VENDOR_SITES_ALL S ,

7528:
7529: CURSOR Lx_Csr_vndr_name(Cx_Resource_Id IN number, cn_org_id in number) IS
7530: SELECT C.LAST_NAME NAME
7531: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7532: PO_VENDOR_SITES_ALL S ,
7533: PO_VENDOR_CONTACTS C
7534: WHERE RSC.RESOURCE_ID = Cx_Resource_Id
7535: and C.VENDOR_CONTACT_ID = RSC.SOURCE_ID
7536: and S.VENDOR_SITE_ID = C.VENDOR_SITE_ID