APPS.IGS_PS_VAL_COUS dependencies on IGS_PS_VER

Line 25: v_course_type IGS_PS_VER.course_type%TYPE;

21: -- to IGS_PS_COURSE offerings which don't breach the IGS_EN_UNITSETPSTYPE
22: -- restrictions. That is, either no restrictions exist for the IGS_EN_UNIT_SET or
23: -- the IGS_PS_COURSE is of a type which is in the defined set.
24: DECLARE
25: v_course_type IGS_PS_VER.course_type%TYPE;
26: CURSOR c_crv IS
27: SELECT crv.course_type
28: FROM IGS_PS_VER crv
29: WHERE crv.course_cd = p_course_cd AND

Line 28: FROM IGS_PS_VER crv

24: DECLARE
25: v_course_type IGS_PS_VER.course_type%TYPE;
26: CURSOR c_crv IS
27: SELECT crv.course_type
28: FROM IGS_PS_VER crv
29: WHERE crv.course_cd = p_course_cd AND
30: crv.version_number = p_crv_version_number;
31: CURSOR c_usctv (
32: cp_course_type IGS_PS_VER.course_type%TYPE) IS

Line 32: cp_course_type IGS_PS_VER.course_type%TYPE) IS

28: FROM IGS_PS_VER crv
29: WHERE crv.course_cd = p_course_cd AND
30: crv.version_number = p_crv_version_number;
31: CURSOR c_usctv (
32: cp_course_type IGS_PS_VER.course_type%TYPE) IS
33: SELECT usctv.course_type
34: FROM IGS_EN_UNIT_SET_COURSE_TYPE_V usctv
35: WHERE usctv.course_type = cp_course_type AND
36: usctv.unit_set_cd = p_unit_set_cd AND