APPS.IGS_HE_ST_PROG_ALL_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 303: CURSOR cur_prog_attempt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

299:
300: END get_fk_igs_ps_ver_all;
301:
302: PROCEDURE check_prog_attempt_exists AS
303: CURSOR cur_prog_attempt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
304: cp_version igs_en_stdnt_ps_att.version_number%TYPE
305: ) IS
306: SELECT 'X' FROM igs_en_stdnt_ps_att
307: WHERE course_cd = cp_course_cd

Line 304: cp_version igs_en_stdnt_ps_att.version_number%TYPE

300: END get_fk_igs_ps_ver_all;
301:
302: PROCEDURE check_prog_attempt_exists AS
303: CURSOR cur_prog_attempt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
304: cp_version igs_en_stdnt_ps_att.version_number%TYPE
305: ) IS
306: SELECT 'X' FROM igs_en_stdnt_ps_att
307: WHERE course_cd = cp_course_cd
308: AND version_number = cp_version;

Line 306: SELECT 'X' FROM igs_en_stdnt_ps_att

302: PROCEDURE check_prog_attempt_exists AS
303: CURSOR cur_prog_attempt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
304: cp_version igs_en_stdnt_ps_att.version_number%TYPE
305: ) IS
306: SELECT 'X' FROM igs_en_stdnt_ps_att
307: WHERE course_cd = cp_course_cd
308: AND version_number = cp_version;
309:
310: l_prog_attempt VARCHAR2(1);