DBA Data[Home] [Help]

APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 158: OKC_K_PARTY_ROLES_B CPL, PO_VENDORS PO

154: BEGIN
155: SELECT PO.SEGMENT1
156: INTO l_program_vendor
157: FROM OKL_LEASE_APPLICATIONS_B LAP, OKC_K_HEADERS_B CHR,
158: OKC_K_PARTY_ROLES_B CPL, PO_VENDORS PO
159: WHERE LAP.PROGRAM_AGREEMENT_ID = CHR.ID
160: AND CHR.ID = CPL.DNZ_CHR_ID
161: AND CPL.JTOT_OBJECT1_CODE = 'OKL_VENDOR'
162: AND CPL.OBJECT1_ID1 = PO.VENDOR_ID