APPS.OKL_QA_DATA_INTEGRITY dependencies on DUAL

Line 203: kle.RESIDUAL_VALUE,

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

Line 204: kle.TRACKED_RESIDUAL,

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

Line 209: kle.residual_code,

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

Line 210: kle.residual_grnty_amount,

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

Line 230: kle.RESIDUAL_VALUE,

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

Line 231: kle.TRACKED_RESIDUAL,

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

Line 236: kle.residual_code,

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

Line 237: kle.residual_grnty_amount,

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

Line 411: From dual

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

Line 556: PROCEDURE check_residual_value(

552: x_return_status OUT NOCOPY VARCHAR2,
553: p_chr_id IN NUMBER);
554:
555: -- Bug 4186455
556: PROCEDURE check_residual_value(
557: x_return_status OUT NOCOPY VARCHAR2,
558: p_chr_id IN NUMBER);
559:
560: -- Bug 4670841