5: FUNCTION crsp_val_cgt_sys_cgt(
6: p_s_course_group_type IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
10: CURSOR c_s_course_group_type IS
11: SELECT closed_ind
12: FROM IGS_LOOKUPS_VIEW
13: WHERE lookup_code = p_s_course_group_type AND
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
10: CURSOR c_s_course_group_type IS
11: SELECT closed_ind
12: FROM IGS_LOOKUPS_VIEW
13: WHERE lookup_code = p_s_course_group_type AND
14: lookup_type = 'COURSE_GROUP_TYPE';
15: BEGIN
16: OPEN c_s_course_group_type;