APPS.IGS_AD_VAL_COOAC dependencies on IGS_AD_CAT_PS_TYPE

Line 23: FROM IGS_AD_CAT_PS_TYPE acct

19: DECLARE
20: v_acct_exists VARCHAR2(1);
21: CURSOR c_acct IS
22: SELECT 'X'
23: FROM IGS_AD_CAT_PS_TYPE acct
24: WHERE acct.admission_cat = p_admission_cat;
25: CURSOR c_acct2 IS
26: SELECT 'X'
27: FROM IGS_AD_CAT_PS_TYPE acct,

Line 27: FROM IGS_AD_CAT_PS_TYPE acct,

23: FROM IGS_AD_CAT_PS_TYPE acct
24: WHERE acct.admission_cat = p_admission_cat;
25: CURSOR c_acct2 IS
26: SELECT 'X'
27: FROM IGS_AD_CAT_PS_TYPE acct,
28: IGS_PS_VER cv
29: WHERE acct.admission_cat = p_admission_cat AND
30: cv.course_cd = p_course_cd AND
31: cv.version_number = p_version_number AND