APPS.IGS_AD_GEN_009 dependencies on IGS_AD_ENT_QF_STAT

Line 84: FROM IGS_AD_ENT_QF_STAT aeqs

80: -- system admission entry status
81: DECLARE
82: CURSOR c_aeqs IS
83: SELECT aeqs.adm_entry_qual_status
84: FROM IGS_AD_ENT_QF_STAT aeqs
85: WHERE aeqs.s_adm_entry_qual_status = p_s_adm_entry_qual_status AND
86: aeqs.system_default_ind = 'Y' AND
87: aeqs.closed_ind = 'N';
88: v_adm_ent_qual_sts IGS_AD_ENT_QF_STAT.adm_entry_qual_status%TYPE;

Line 88: v_adm_ent_qual_sts IGS_AD_ENT_QF_STAT.adm_entry_qual_status%TYPE;

84: FROM IGS_AD_ENT_QF_STAT aeqs
85: WHERE aeqs.s_adm_entry_qual_status = p_s_adm_entry_qual_status AND
86: aeqs.system_default_ind = 'Y' AND
87: aeqs.closed_ind = 'N';
88: v_adm_ent_qual_sts IGS_AD_ENT_QF_STAT.adm_entry_qual_status%TYPE;
89: BEGIN
90: FOR v_aeqs_rec IN c_aeqs LOOP
91: IF c_aeqs%ROWCOUNT > 1 THEN
92: v_adm_ent_qual_sts := NULL;