2182: sca.adm_nominated_course_cd = p_nominated_course_cd AND
2183: sca.adm_sequence_number = p_acai_sequence_number;
2184:
2185:
2186: v_cty_res_typ_ind IGS_PS_TYPE.research_type_ind%TYPE;
2187:
2188: CURSOR c_crv_cty IS
2189: SELECT cty.research_type_ind
2190: FROM IGS_PS_VER crv,
2187:
2188: CURSOR c_crv_cty IS
2189: SELECT cty.research_type_ind
2190: FROM IGS_PS_VER crv,
2191: IGS_PS_TYPE cty
2192: WHERE crv.course_cd = p_course_cd AND
2193: crv.version_number = p_crv_version_number AND
2194: crv.course_type = cty.course_type;
2195: