APPS.IGS_ST_GEN_002 dependencies on IGS_PS_TYPE

Line 30: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;

26: -- If the level cannot be determined a null value is returned.
27: -- This routine will eventually be replaced with an level field
28: -- on the course_type table.
29: DECLARE
30: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
31: CURSOR c_cty IS
32: SELECT cty.govt_course_type
33: FROM IGS_PS_VER cv,
34: IGS_PS_TYPE cty

Line 34: IGS_PS_TYPE cty

30: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
31: CURSOR c_cty IS
32: SELECT cty.govt_course_type
33: FROM IGS_PS_VER cv,
34: IGS_PS_TYPE cty
35: WHERE cv.course_cd = p_course_cd AND
36: cv.version_number = p_version_number AND
37: cty.course_type = cv.course_type;
38: BEGIN