APPS.IGS_PS_VAL_CGR dependencies on IGS_PS_GRP_TYPE

Line 10: v_closed_ind IGS_PS_GRP_TYPE.closed_ind%TYPE;

6: FUNCTION crsp_val_cgr_type(
7: p_course_group_type IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_GRP_TYPE.closed_ind%TYPE;
11: CURSOR c_course_group_type IS
12: SELECT closed_ind
13: FROM IGS_PS_GRP_TYPE
14: WHERE course_group_type = p_course_group_type;

Line 13: FROM IGS_PS_GRP_TYPE

9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_GRP_TYPE.closed_ind%TYPE;
11: CURSOR c_course_group_type IS
12: SELECT closed_ind
13: FROM IGS_PS_GRP_TYPE
14: WHERE course_group_type = p_course_group_type;
15: BEGIN
16: OPEN c_course_group_type;
17: FETCH c_course_group_type INTO v_closed_ind;