APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_PS_AWARD

Line 213: (cp_course_cd igs_ps_award.course_cd%TYPE,

209:
210:
211: -- Cursor to determine if course has qual aim
212: CURSOR c_award_qualaim
213: (cp_course_cd igs_ps_award.course_cd%TYPE,
214: cp_version_number igs_ps_award.version_number%TYPE) IS
215: SELECT DECODE(count(award_cd), 0, 'N', 'Y')
216: FROM igs_ps_award
217: WHERE course_cd = cp_course_cd

Line 214: cp_version_number igs_ps_award.version_number%TYPE) IS

210:
211: -- Cursor to determine if course has qual aim
212: CURSOR c_award_qualaim
213: (cp_course_cd igs_ps_award.course_cd%TYPE,
214: cp_version_number igs_ps_award.version_number%TYPE) IS
215: SELECT DECODE(count(award_cd), 0, 'N', 'Y')
216: FROM igs_ps_award
217: WHERE course_cd = cp_course_cd
218: AND version_number = cp_version_number

Line 216: FROM igs_ps_award

212: CURSOR c_award_qualaim
213: (cp_course_cd igs_ps_award.course_cd%TYPE,
214: cp_version_number igs_ps_award.version_number%TYPE) IS
215: SELECT DECODE(count(award_cd), 0, 'N', 'Y')
216: FROM igs_ps_award
217: WHERE course_cd = cp_course_cd
218: AND version_number = cp_version_number
219: AND closed_ind = 'N';
220: