APPS.IGS_AD_VAL_SAFT dependencies on IGS_PS_UNIT_INT_LVL

Line 173: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE;

169: RETURN BOOLEAN AS
170: BEGIN -- crsp_val_uicl_closed
171: -- This module checks if a course type group is open.
172: DECLARE
173: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE;
174: CURSOR c_uicl IS
175: SELECT uicl.closed_ind
176: FROM IGS_PS_UNIT_INT_LVL uicl
177: WHERE uicl.unit_int_course_level_cd = p_unit_int_course_level_cd;

Line 176: FROM IGS_PS_UNIT_INT_LVL uicl

172: DECLARE
173: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE;
174: CURSOR c_uicl IS
175: SELECT uicl.closed_ind
176: FROM IGS_PS_UNIT_INT_LVL uicl
177: WHERE uicl.unit_int_course_level_cd = p_unit_int_course_level_cd;
178: BEGIN
179: -- Set the default message number
180: p_message_name := null;