APPS.OKL_QA_DATA_INTEGRITY dependencies on DUAL

Line 205: kle.RESIDUAL_VALUE,

201: CURSOR l_toplne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS
202: SELECT kle.name,
203: kle.CURRENCY_CODE,
204: kle.id,
205: kle.RESIDUAL_VALUE,
206: kle.TRACKED_RESIDUAL,
207: kle.CAPITAL_REDUCTION,
208: kle.TRADEIN_AMOUNT,
209: kle.RVI_PREMIUM,

Line 206: kle.TRACKED_RESIDUAL,

202: SELECT kle.name,
203: kle.CURRENCY_CODE,
204: kle.id,
205: kle.RESIDUAL_VALUE,
206: kle.TRACKED_RESIDUAL,
207: kle.CAPITAL_REDUCTION,
208: kle.TRADEIN_AMOUNT,
209: kle.RVI_PREMIUM,
210: kle.OEC,

Line 211: kle.residual_code,

207: kle.CAPITAL_REDUCTION,
208: kle.TRADEIN_AMOUNT,
209: kle.RVI_PREMIUM,
210: kle.OEC,
211: kle.residual_code,
212: kle.residual_grnty_amount,
213: sub_kle.capital_amount amount,
214: sub_kle.line_number
215: FROM OKL_K_LINES_FULL_V kle,

Line 212: kle.residual_grnty_amount,

208: kle.TRADEIN_AMOUNT,
209: kle.RVI_PREMIUM,
210: kle.OEC,
211: kle.residual_code,
212: kle.residual_grnty_amount,
213: sub_kle.capital_amount amount,
214: sub_kle.line_number
215: FROM OKL_K_LINES_FULL_V kle,
216: OKL_K_LINES_FULL_V sub_kle,

Line 232: kle.RESIDUAL_VALUE,

228: SELECT kle.name,
229: kle.amount,
230: kle.CURRENCY_CODE,
231: kle.id,
232: kle.RESIDUAL_VALUE,
233: kle.TRACKED_RESIDUAL,
234: kle.CAPITAL_REDUCTION,
235: kle.TRADEIN_AMOUNT,
236: kle.RVI_PREMIUM,

Line 233: kle.TRACKED_RESIDUAL,

229: kle.amount,
230: kle.CURRENCY_CODE,
231: kle.id,
232: kle.RESIDUAL_VALUE,
233: kle.TRACKED_RESIDUAL,
234: kle.CAPITAL_REDUCTION,
235: kle.TRADEIN_AMOUNT,
236: kle.RVI_PREMIUM,
237: kle.OEC,

Line 238: kle.residual_code,

234: kle.CAPITAL_REDUCTION,
235: kle.TRADEIN_AMOUNT,
236: kle.RVI_PREMIUM,
237: kle.OEC,
238: kle.residual_code,
239: kle.residual_grnty_amount,
240: -- bug 5034519
241: kle.start_date,
242: --Bug# 4631549

Line 239: kle.residual_grnty_amount,

235: kle.TRADEIN_AMOUNT,
236: kle.RVI_PREMIUM,
237: kle.OEC,
238: kle.residual_code,
239: kle.residual_grnty_amount,
240: -- bug 5034519
241: kle.start_date,
242: --Bug# 4631549
243: kle.expected_asset_cost

Line 413: From dual

409:
410:
411: Cursor cust_site_csr( siteId NUMBER, accntId NUMBER, rleCode VARCHAR2 ) IS
412: Select 'Y' isThere
413: From dual
414: where Exists (
415: Select a.cust_acct_site_id
416: From HZ_CUST_SITE_USES_ALL a,
417: HZ_CUST_ACCT_SITES_ALL b

Line 604: PROCEDURE check_residual_value(

600: x_return_status OUT NOCOPY VARCHAR2,
601: p_chr_id IN NUMBER);
602:
603: -- Bug 4186455
604: PROCEDURE check_residual_value(
605: x_return_status OUT NOCOPY VARCHAR2,
606: p_chr_id IN NUMBER);
607:
608: -- Bug 4670841