873: --
874: -- cursor to check whether the given award code exists against system award type COURSE
875: CURSOR cur_award_cd IS
876: SELECT 'x' 877: FROM igs_ps_awd 878: WHERE s_award_type = 'COURSE' AND
879: award_cd = p_award_cd AND
880: closed_ind = 'N';
881: