APPS.OKL_ASD_PVT dependencies on OKX_ASST_DEP_METHODS_V

Line 428: -- Description : FK validation with OKX_ASST_DEP_METHODS_V

424: --------------------------------20-------------------------------------------------
425: -- Start of Commnets
426: -- Badrinath Kuchibholta
427: -- Procedure Name : validate_dprn_mtd_tax
428: -- Description : FK validation with OKX_ASST_DEP_METHODS_V
429: -- Business Rules :
430: -- Parameters : OUT Return Status, IN Rec Info
431: -- Version : 1.0
432: -- End of Commnets

Line 438: CURSOR c_dprn_mtd_tax_validate(p_deprn_method OKX_ASST_DEP_METHODS_V.METHOD_CODE%TYPE) is

434: PROCEDURE validate_dprn_mtd_tax(x_return_status OUT NOCOPY VARCHAR2,
435: p_asdv_rec IN asdv_rec_type) IS
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

Line 442: FROM OKX_ASST_DEP_METHODS_V

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:
445: BEGIN
446: -- initialize return status