APPS.IGS_EN_SUA_API dependencies on IGS_PS_VER

Line 607: CURSOR cur_max_wlst_stud_ps(cp_course_cd igs_ps_ver.course_cd%TYPE,

603: person_id = cp_person_id AND
604: course_cd = cp_course_cd;
605:
606: -- cursor that gets max_wlst_stud_ps given course and version
607: CURSOR cur_max_wlst_stud_ps(cp_course_cd igs_ps_ver.course_cd%TYPE,
608: cp_version_number igs_ps_ver.version_number%TYPE) IS
609: SELECT max_wlst_per_stud
610: FROM igs_ps_ver
611: WHERE

Line 608: cp_version_number igs_ps_ver.version_number%TYPE) IS

604: course_cd = cp_course_cd;
605:
606: -- cursor that gets max_wlst_stud_ps given course and version
607: CURSOR cur_max_wlst_stud_ps(cp_course_cd igs_ps_ver.course_cd%TYPE,
608: cp_version_number igs_ps_ver.version_number%TYPE) IS
609: SELECT max_wlst_per_stud
610: FROM igs_ps_ver
611: WHERE
612: course_cd = cp_course_cd AND

Line 610: FROM igs_ps_ver

606: -- cursor that gets max_wlst_stud_ps given course and version
607: CURSOR cur_max_wlst_stud_ps(cp_course_cd igs_ps_ver.course_cd%TYPE,
608: cp_version_number igs_ps_ver.version_number%TYPE) IS
609: SELECT max_wlst_per_stud
610: FROM igs_ps_ver
611: WHERE
612: course_cd = cp_course_cd AND
613: version_number = cp_version_number;
614: