APPS.IGS_AD_VAL_CRS_ADMPERD dependencies on IGS_PS_VER

Line 25: cp_course_cd IGS_PS_VER.course_cd%TYPE,

21: -- * If the admission process type is Transfer then the course version must not
22: -- be a generic course.
23: DECLARE
24: CURSOR c_cvcsct (
25: cp_course_cd IGS_PS_VER.course_cd%TYPE,
26: cp_version_number IGS_PS_VER.version_number%TYPE) IS
27: SELECT cs.s_course_status,
28: cv.expiry_dt,
29: cv.generic_course_ind,

Line 26: cp_version_number IGS_PS_VER.version_number%TYPE) IS

22: -- be a generic course.
23: DECLARE
24: CURSOR c_cvcsct (
25: cp_course_cd IGS_PS_VER.course_cd%TYPE,
26: cp_version_number IGS_PS_VER.version_number%TYPE) IS
27: SELECT cs.s_course_status,
28: cv.expiry_dt,
29: cv.generic_course_ind,
30: ct.govt_course_type

Line 31: FROM IGS_PS_VER cv,

27: SELECT cs.s_course_status,
28: cv.expiry_dt,
29: cv.generic_course_ind,
30: ct.govt_course_type
31: FROM IGS_PS_VER cv,
32: IGS_PS_STAT cs,
33: IGS_PS_TYPE ct
34: WHERE course_cd = cp_course_cd AND
35: version_number = cp_version_number AND