APPS.IGS_PS_VAL_CAW dependencies on IGS_PS_VER

Line 50: FROM IGS_PS_VER,

46: RETURN BOOLEAN AS
47: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;
48: CURSOR c_get_award_crs_ind IS
49: SELECT award_course_ind
50: FROM IGS_PS_VER,
51: IGS_PS_TYPE
52: WHERE course_cd = p_course_cd AND
53: version_number = p_version_number AND
54: IGS_PS_VER.course_type = IGS_PS_TYPE.course_type;

Line 54: IGS_PS_VER.course_type = IGS_PS_TYPE.course_type;

50: FROM IGS_PS_VER,
51: IGS_PS_TYPE
52: WHERE course_cd = p_course_cd AND
53: version_number = p_version_number AND
54: IGS_PS_VER.course_type = IGS_PS_TYPE.course_type;
55: BEGIN
56: OPEN c_get_award_crs_ind;
57: FETCH c_get_award_crs_ind INTO v_award_crs_ind;
58: IF (c_get_award_crs_ind%FOUND) THEN