50: -- Check if another adm_entry_qual_status record exists with the system
51: -- default indicator set to 'Y'
52: DECLARE
53: v_count_rec NUMBER;
54: v_sys_def_ind IGS_AD_ENT_QF_STAT.system_default_ind%TYPE;
55: CURSOR c_count IS
56: SELECT count(*),
57: system_default_ind
58: FROM IGS_AD_ENT_QF_STAT aeqs
54: v_sys_def_ind IGS_AD_ENT_QF_STAT.system_default_ind%TYPE;
55: CURSOR c_count IS
56: SELECT count(*),
57: system_default_ind
58: FROM IGS_AD_ENT_QF_STAT aeqs
59: WHERE aeqs.adm_entry_qual_status <> p_adm_entry_qual_status AND
60: aeqs.s_adm_entry_qual_status = p_s_adm_entry_qual_status AND
61: aeqs.system_default_ind = 'Y'
62: GROUP BY system_default_ind;