APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_HE_CODE_MAP_VAL

Line 85: SELECT Map2 FROM Igs_he_code_map_val

81: AND ( (approved_result = l_approved_result) OR (approved_result IS NULL AND l_approved_result IS NULL) ) ;
82:
83: /* this will pickup data from HESA table for Awarding body, based in the association code */
84: CURSOR Cur_Awarding_body (l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS
85: SELECT Map2 FROM Igs_he_code_map_val
86: WHERE Association_code = 'UCAS_OSS_AWD_BDY_ASSOC'
87: AND Map1 = l_awarding_body;
88:
89: /* this will pickup data from HESA table for Subject code, based in the association code */

Line 91: SELECT Map2 FROM Igs_he_code_map_val

87: AND Map1 = l_awarding_body;
88:
89: /* this will pickup data from HESA table for Subject code, based in the association code */
90: CURSOR Cur_subject_code (l_subject_code igs_uc_com_ebl_subj.subject_code%TYPE) IS
91: SELECT Map2 FROM Igs_he_code_map_val
92: WHERE Association_code = 'UCAS_OSS_SBJ_ASSOC'
93: AND Map1 = l_subject_code;
94:
95: /* this will pickup data from HESA table for Exam_level, based in the association code */

Line 97: SELECT Map2 FROM Igs_he_code_map_val

93: AND Map1 = l_subject_code;
94:
95: /* this will pickup data from HESA table for Exam_level, based in the association code */
96: CURSOR Cur_exam_level (l_exam_level igs_uc_com_ebl_subj.exam_level%TYPE) IS
97: SELECT Map2 FROM Igs_he_code_map_val
98: WHERE Association_code = 'UCAS_OSS_AWD_ASSOC'
99: AND Map1 = l_exam_level;
100:
101: /* this is to get values from igs_uc_qual_dets table for updation when manually entered */

Line 156: FROM igs_he_code_map_val msbj

152: )
153: AND apr.subject_id IN ( SELECT subject_id
154: FROM igs_uc_com_ebl_subj
155: WHERE subject_code IN ( SELECT msbj.map1
156: FROM igs_he_code_map_val msbj
157: WHERE msbj.association_code = 'UCAS_OSS_SBJ_ASSOC'
158: AND msbj.map2 = cp_subject_code )
159: )
160: AND apr.year = cp_year

Line 163: FROM igs_he_code_map_val mawb

159: )
160: AND apr.year = cp_year
161: AND apr.sitting = cp_sitting
162: AND apr.award_body IN ( SELECT mawb.map1
163: FROM igs_he_code_map_val mawb
164: WHERE mawb.association_code = 'UCAS_OSS_AWD_BDY_ASSOC'
165: AND mawb.map2 = cp_awarding_body
166: )
167: AND apr.exam_level IN ( SELECT mawd.map1

Line 168: FROM igs_he_code_map_val mawd

164: WHERE mawb.association_code = 'UCAS_OSS_AWD_BDY_ASSOC'
165: AND mawb.map2 = cp_awarding_body
166: )
167: AND apr.exam_level IN ( SELECT mawd.map1
168: FROM igs_he_code_map_val mawd
169: WHERE mawd.association_code = 'UCAS_OSS_AWD_ASSOC'
170: AND mawd.map2 = cp_exam_level
171: )
172: AND ( (NVL(UPPER(TRIM(apr.ebl_amended_result)),UPPER(TRIM(apr.ebl_result))) = cp_approved_result)