APPS.OKL_ASD_PVT dependencies on DUAL

Line 111: FROM DUAL

107: p_asdv_rec IN asdv_rec_type) IS
108: ln_dummy number := 0;
109: CURSOR c_tal_id_validate(p_id number) is
110: SELECT 1
111: FROM DUAL
112: WHERE EXISTS (SELECT '1'
113: FROM OKL_TXL_ASSETS_V
114: WHERE id = p_id);
115:

Line 292: FROM DUAL

288: p_asdv_rec IN asdv_rec_type) IS
289: ln_dummy number := 0;
290: CURSOR c_target_kle_id_validate(p_id OKL_TXD_ASSETS_V.TARGET_KLE_ID%TYPE) is
291: SELECT 1
292: FROM DUAL
293: WHERE EXISTS (SELECT '1'
294: FROM OKL_K_LINES_V kle
295: WHERE kle.id = p_id);
296:

Line 366: FROM DUAL

362:
363: ln_dummy number := 0;
364: CURSOR c_tax_book_validate(p_name OKX_ASST_BK_CONTROLS_V.NAME%TYPE) is
365: SELECT 1
366: FROM DUAL
367: WHERE EXISTS (SELECT id1
368: FROM OKX_ASST_BK_CONTROLS_V
369: WHERE name = p_name
370: AND book_class = 'TAX');

Line 440: FROM DUAL

436:
437: ln_dummy number := 0;
438: CURSOR c_dprn_mtd_tax_validate(p_deprn_method OKX_ASST_DEP_METHODS_V.METHOD_CODE%TYPE) is
439: SELECT 1
440: FROM DUAL
441: WHERE EXISTS (SELECT method_code
442: FROM OKX_ASST_DEP_METHODS_V
443: WHERE method_code = p_deprn_method);
444:

Line 1273: -- Calling the Validate Procedure to validate Individual Attributes

1269: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Asset_number');
1270: x_return_status := OKC_API.G_RET_STS_ERROR;
1271: END IF;
1272: /************************ HAND-CODED *********************************/
1273: -- Calling the Validate Procedure to validate Individual Attributes
1274: validate_tal_id(x_return_status => l_return_status,
1275: p_asdv_rec => p_asdv_rec);
1276: -- Store the Highest Degree of Error
1277: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN