DBA Data[Home] [Help]

APPS.OKC_SAC_PVT dependencies on OKC_SUBCLASSES_B

Line 394: FROM okc_subclasses_b scs

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: