390: procedure validate_scs_code(p_sacv_rec IN sacv_rec_type,
391: x_return_status OUT NOCOPY VARCHAR2) is
392: CURSOR l_scs_code_csr IS
393: SELECT '1' 394: FROM okc_subclasses_b scs 395: WHERE scs.code = p_sacv_rec.scs_code and
396: sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate);
397: l_dummy_var VARCHAR2(1):='0';
398: