APPS.OKL_ASD_PVT dependencies on OKX_ASST_BK_CONTROLS_V

Line 354: -- Description : FK validation with OKX_ASST_BK_CONTROLS_V

350: ------------------------------19----------------------------------------------
351: -- Start of Commnets
352: -- Badrinath Kuchibholta
353: -- Procedure Name : validate_tax_book
354: -- Description : FK validation with OKX_ASST_BK_CONTROLS_V
355: -- Business Rules :
356: -- Parameters : OUT Return Status, IN Rec Info
357: -- Version : 1.0
358: -- End of Commnets

Line 364: CURSOR c_tax_book_validate(p_name OKX_ASST_BK_CONTROLS_V.NAME%TYPE) is

360: PROCEDURE validate_tax_book(x_return_status OUT NOCOPY VARCHAR2,
361: p_asdv_rec IN asdv_rec_type) IS
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

Line 368: FROM OKX_ASST_BK_CONTROLS_V

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');
371:
372: BEGIN