APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_HE_CODE_VALUES

Line 216: --smaddali modified cursor to select only open code_values from igs_he_code_values ,bug 2730388

212: WHERE Person_id = l_person_id
213: AND course_cd = l_course_cd;
214:
215: --get the Highest qualification on entry as the highest ranked qualification
216: --smaddali modified cursor to select only open code_values from igs_he_code_values ,bug 2730388
217: --Correct the comparision done in this cursor to compare Iagsta.grading_schema_cd with the Iuqd.grading_schema_cd
218: --Not with the Exam Level as mentioned in bug 2782618
219: CURSOR Cur_highest_grade (l_person_id igs_he_st_spa.person_id%TYPE ,
220: p_commencement_dt igs_he_st_spa.commencement_dt%TYPE) IS

Line 245: FROM Igs_he_code_values

241: AND Iagsgv.version_number = Iagsta.to_version_number
242: AND Iagsgv.grade = Iagsta.to_grade
243: AND (Iuqd.Year IS NULL OR Iuqd.Year <= TO_CHAR(p_commencement_dt,'YYYY'))
244: AND EXISTS (SELECT 'X'
245: FROM Igs_he_code_values
246: WHERE Code_type = 'HESA_HIGH_QUAL_ON_ENT'
247: AND Value = Iagsta.to_grading_schema_cd
248: AND NVL(closed_ind,'N') = 'N' )
249: ORDER BY Iagsgv.rank ASC ;