APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKC_K_HEADERS_B

Line 19: FROM OKC_K_HEADERS_B KHR, OKL_LEASE_APPLICATIONS_B LAP

15: x_resultout := FND_API.G_RET_STS_SUCCESS;
16: BEGIN
17: SELECT KHR.CONTRACT_NUMBER
18: INTO l_credit_line_number
19: FROM OKC_K_HEADERS_B KHR, OKL_LEASE_APPLICATIONS_B LAP
20: WHERE KHR.SCS_CODE = 'CREDITLINE_CONTRACT'
21: AND LAP.CREDIT_LINE_ID = KHR.ID
22: AND LAP.ID = l_lease_app_id;
23:

Line 53: FROM OKC_K_HEADERS_B KHR,

49: x_resultout := FND_API.G_RET_STS_SUCCESS;
50: BEGIN
51: SELECT KHR.END_DATE
52: INTO l_credit_line_expiration_date
53: FROM OKC_K_HEADERS_B KHR,
54: OKL_LEASE_APPLICATIONS_B LAP
55: WHERE KHR.SCS_CODE = 'CREDITLINE_CONTRACT'
56: AND LAP.CREDIT_LINE_ID = KHR.ID
57: AND LAP.ID = l_lease_app_id;

Line 157: FROM OKL_LEASE_APPLICATIONS_B LAP, OKC_K_HEADERS_B CHR,

153: x_resultout := FND_API.G_RET_STS_SUCCESS;
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'

Line 194: FROM OKC_K_HEADERS_B KHR, OKL_LEASE_APPLICATIONS_B LAP

190: x_resultout := FND_API.G_RET_STS_SUCCESS;
191: BEGIN
192: SELECT KHR.CONTRACT_NUMBER
193: INTO l_program_agreement_number
194: FROM OKC_K_HEADERS_B KHR, OKL_LEASE_APPLICATIONS_B LAP
195: WHERE KHR.SCS_CODE = 'PROGRAM'
196: AND LAP.PROGRAM_AGREEMENT_ID = KHR.ID
197: AND LAP.ID = l_lease_app_id;
198: