APPS.IGS_AD_VAL_AC dependencies on IGS_AD_PRCS_CAT

Line 15: FROM IGS_AD_PRCS_CAT apc

11: DECLARE
12: v_admission_cat IGS_AD_CAT.admission_cat%TYPE;
13: CURSOR c_apc IS
14: SELECT apc.admission_cat
15: FROM IGS_AD_PRCS_CAT apc
16: WHERE apc.admission_cat = p_admission_cat
17: AND closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)
18: BEGIN
19: -- Validate if the admission_cat can be updated