APPS.IGS_PS_VAL_CGM dependencies on IGS_PS_GRP

Line 10: v_closed_ind IGS_PS_GRP.closed_ind%TYPE;

6: FUNCTION crsp_val_cgm_crs_grp(
7: p_course_group_cd IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_GRP.closed_ind%TYPE;
11: CURSOR c_course_group IS
12: SELECT closed_ind
13: FROM IGS_PS_GRP
14: WHERE course_group_cd = p_course_group_cd;

Line 13: FROM IGS_PS_GRP

9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_GRP.closed_ind%TYPE;
11: CURSOR c_course_group IS
12: SELECT closed_ind
13: FROM IGS_PS_GRP
14: WHERE course_group_cd = p_course_group_cd;
15: BEGIN
16: OPEN c_course_group;
17: FETCH c_course_group INTO v_closed_ind;