120: state_cd = p_state_cd;
121: CURSOR c_aseat IS
122: SELECT aus_scndry_edu_ass_type,
123: state_cd
124: FROM IGS_AD_AUSE_ED_AS_TY
125: WHERE aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type OR
126: p_aus_scndry_edu_ass_type IS NULL OR
127: tac_aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type;
128: CURSOR c_ases IS
226: -- This procedure inserts a new IGS_AD_AUS_SEC_ED_SC record
227: DECLARE
228: CURSOR c_aseat IS
229: SELECT aus_scndry_edu_ass_type
230: FROM IGS_AD_AUSE_ED_AS_TY
231: WHERE aus_scndry_edu_ass_type = p_subject_ass_type OR
232: tac_aus_scndry_edu_ass_type = p_subject_ass_type;
233: v_aseat_rec c_aseat%ROWTYPE;
234: v_subject_ass_type IGS_AD_AUS_SEC_ED_SU.subject_ass_type%TYPE DEFAULT NULL;