APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_PS_VER

Line 1090: CURSOR c_max_wlst_stud_ps(cp_course_cd igs_ps_ver.course_cd%TYPE,

1086: person_id = cp_person_id AND
1087: course_cd = cp_course_cd;
1088:
1089: -- cursor to get program level max_wlst_per_stud for a course and version
1090: CURSOR c_max_wlst_stud_ps(cp_course_cd igs_ps_ver.course_cd%TYPE,
1091: cp_version_number igs_ps_ver.version_number%TYPE) IS
1092: SELECT max_wlst_per_stud
1093: FROM igs_ps_ver
1094: WHERE

Line 1091: cp_version_number igs_ps_ver.version_number%TYPE) IS

1087: course_cd = cp_course_cd;
1088:
1089: -- cursor to get program level max_wlst_per_stud for a course and version
1090: CURSOR c_max_wlst_stud_ps(cp_course_cd igs_ps_ver.course_cd%TYPE,
1091: cp_version_number igs_ps_ver.version_number%TYPE) IS
1092: SELECT max_wlst_per_stud
1093: FROM igs_ps_ver
1094: WHERE
1095: course_cd = cp_course_cd AND

Line 1093: FROM igs_ps_ver

1089: -- cursor to get program level max_wlst_per_stud for a course and version
1090: CURSOR c_max_wlst_stud_ps(cp_course_cd igs_ps_ver.course_cd%TYPE,
1091: cp_version_number igs_ps_ver.version_number%TYPE) IS
1092: SELECT max_wlst_per_stud
1093: FROM igs_ps_ver
1094: WHERE
1095: course_cd = cp_course_cd AND
1096: version_number = cp_version_number;
1097: