APPS.IGS_PS_VAL_UV dependencies on IGS_PS_UNIT_INT_LVL

Line 101: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE;

97: FUNCTION crsp_val_uv_uicl(
98: p_unit_int_course_level_cd IN VARCHAR2 ,
99: p_message_name OUT NOCOPY VARCHAR2 )
100: RETURN BOOLEAN AS
101: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE;
102: CURSOR c_uv_uicl_closed_ind IS
103: SELECT closed_ind
104: FROM IGS_PS_UNIT_INT_LVL
105: WHERE unit_int_course_level_cd = p_unit_int_course_level_cd AND

Line 104: FROM IGS_PS_UNIT_INT_LVL

100: RETURN BOOLEAN AS
101: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE;
102: CURSOR c_uv_uicl_closed_ind IS
103: SELECT closed_ind
104: FROM IGS_PS_UNIT_INT_LVL
105: WHERE unit_int_course_level_cd = p_unit_int_course_level_cd AND
106: closed_ind = 'Y';
107: BEGIN
108: OPEN c_uv_uicl_closed_ind;