APPS.IGS_AD_VAL_SAFT dependencies on IGS_PS_TYPE_GRP

Line 130: v_closed_ind IGS_PS_TYPE_GRP.closed_ind%TYPE;

126: RETURN BOOLEAN AS
127: BEGIN -- crsp_val_ctg_closed
128: -- This module checks if a course type group is open.
129: DECLARE
130: v_closed_ind IGS_PS_TYPE_GRP.closed_ind%TYPE;
131: CURSOR c_ctg IS
132: SELECT ctg.closed_ind
133: FROM IGS_PS_TYPE_GRP ctg
134: WHERE ctg.course_type_group_cd = p_course_type_group_cd;

Line 133: FROM IGS_PS_TYPE_GRP ctg

129: DECLARE
130: v_closed_ind IGS_PS_TYPE_GRP.closed_ind%TYPE;
131: CURSOR c_ctg IS
132: SELECT ctg.closed_ind
133: FROM IGS_PS_TYPE_GRP ctg
134: WHERE ctg.course_type_group_cd = p_course_type_group_cd;
135: BEGIN
136: -- Set the default message number
137: p_message_name := null;