103: --Cursor to get the subject of the previous qualification which is defined as OSS_QUAL_1ST_DEGREE
104: -- smaddali modified cursor to get only open code_values ,bug 2730388
105: CURSOR c_subject IS
106: SELECT a.subject_code
107: FROM igs_uc_qual_dets a
108: WHERE a.person_id = p_person_id
109: AND EXISTS (SELECT 'X'
110: FROM igs_he_code_values b
111: WHERE b.value = a.exam_level
118: SELECT govt_field_of_study
119: FROM IGS_PS_FLD_OF_STUDY PFS
120: WHERE field_of_study = p_subject;
121:
122: l_subject igs_uc_qual_dets.subject_code%TYPE ;
123:
124: BEGIN
125: l_subject := NULL;
126: OPEN c_subject ;