APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_CODE_VALUES

Line 94: is also defined as the 1t qualification in igs_he_code_values for code_type 'OSS_QUAL_1ST_DEGREE'

90: /***************************************************************
91: Created By : bayadav
92: Date Created By : 25-Mar-2002
93: Purpose :This procedure gets the subject of the previous qualification which
94: is also defined as the 1t qualification in igs_he_code_values for code_type 'OSS_QUAL_1ST_DEGREE'
95: The govt field of study for the subject is returned
96: Known Limitations,Enhancements or Remarks:
97: Change History :
98: Who When What

Line 110: FROM igs_he_code_values b

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
112: AND b.code_type = 'OSS_QUAL_1ST_DEGREE'
113: AND NVL(b.closed_ind,'N') = 'N' )
114: ORDER BY a.year DESC;