APPS.OKL_TAL_PVT dependencies on OKX_ASST_DEP_METHODS_V

Line 1102: -- Description : FK validation with OKX_ASST_DEP_METHODS_V

1098: --------------------------------20-------------------------------------------------
1099: -- Start of Commnets
1100: -- Badrinath Kuchibholta
1101: -- Procedure Name : validate_deprn_method
1102: -- Description : FK validation with OKX_ASST_DEP_METHODS_V
1103: -- Business Rules :
1104: -- Parameters : OUT Return Status, IN Rec Info
1105: -- Version : 1.0
1106: -- End of Commnets

Line 1112: CURSOR c_deprn_method_validate(p_deprn_method OKX_ASST_DEP_METHODS_V.METHOD_CODE%TYPE) is

1108: PROCEDURE validate_deprn_method(x_return_status OUT NOCOPY VARCHAR2,
1109: p_talv_rec IN talv_rec_type) IS
1110:
1111: ln_dummy number := 0;
1112: CURSOR c_deprn_method_validate(p_deprn_method OKX_ASST_DEP_METHODS_V.METHOD_CODE%TYPE) is
1113: SELECT 1
1114: FROM DUAL
1115: WHERE EXISTS (SELECT method_code
1116: FROM OKX_ASST_DEP_METHODS_V

Line 1116: FROM OKX_ASST_DEP_METHODS_V

1112: CURSOR c_deprn_method_validate(p_deprn_method OKX_ASST_DEP_METHODS_V.METHOD_CODE%TYPE) is
1113: SELECT 1
1114: FROM DUAL
1115: WHERE EXISTS (SELECT method_code
1116: FROM OKX_ASST_DEP_METHODS_V
1117: WHERE method_code = p_deprn_method);
1118:
1119: BEGIN
1120: -- initialize return status