APPS.IGS_PS_VAL_CRC dependencies on IGS_PS_CAT

Line 16: v_closed_ind IGS_PS_CAT.closed_ind%TYPE;

12: FUNCTION crsp_val_crc_crs_cat(
13: p_course_cat IN VARCHAR2 ,
14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS
16: v_closed_ind IGS_PS_CAT.closed_ind%TYPE;
17: CURSOR c_course_cat IS
18: SELECT closed_ind
19: FROM IGS_PS_CAT
20: WHERE course_cat = p_course_cat;

Line 19: FROM IGS_PS_CAT

15: RETURN BOOLEAN AS
16: v_closed_ind IGS_PS_CAT.closed_ind%TYPE;
17: CURSOR c_course_cat IS
18: SELECT closed_ind
19: FROM IGS_PS_CAT
20: WHERE course_cat = p_course_cat;
21: BEGIN
22: OPEN c_course_cat;
23: FETCH c_course_cat INTO v_closed_ind;