APPS.IGS_AD_VAL_APAC dependencies on IGS_AD_PRCS_CAT

Line 252: FROM IGS_AD_PRCS_CAT

248: admission_cat = cp_admission_cat;
249: CURSOR c_apc(
250: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
251: SELECT s_admission_process_type
252: FROM IGS_AD_PRCS_CAT
253: WHERE admission_cat = cp_admission_cat
254: AND closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)
255: v_apapc_rec c_apapc%ROWTYPE;
256: v_rowid VARCHAR2(25);