DBA Data[Home] [Help]

APPS.OKL_ASD_PVT dependencies on OKL_K_LINES_V

Line 281: -- Description : FK validation with OKL_K_LINES_V

277: --------------------------------------5-------------------------------------------
278: -- Start of Commnets
279: -- Badrinath Kuchibholta
280: -- Procedure Name : Validate_target_kle_id
281: -- Description : FK validation with OKL_K_LINES_V
282: -- Business Rules :
283: -- Parameters : OUT Return Status, IN Rec Info
284: -- Version : 1.0
285: -- End of Commnets

Line 294: FROM OKL_K_LINES_V kle

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:
297: BEGIN
298: -- initialize return status