APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_HE_CODE_MAP_VAL

Line 73: FROM igs_he_code_map_val

69:
70: -- get the HESA code for oss qualification aim
71: CURSOR Cur_qual_aim (cp_student_qual_aim Igs_he_st_spa.Student_qual_aim%TYPE) IS
72: SELECT map1
73: FROM igs_he_code_map_val
74: WHERE Association_code ='OSS_HESA_AWD_ASSOC'
75: AND Map2 = cp_Student_qual_aim ;
76:
77: -- get all the records for passed exam level of the student where year of qualification is null or

Line 296: l_Qual_aim igs_he_code_map_val.map1%TYPE ;

292: l_last_update_date Igs_uc_qual_dets.Last_update_date%TYPE ;
293: l_record_inserted NUMBER := 0;
294: l_record_updated NUMBER := 0;
295: l_hesa_st_spau_id Igs_he_st_spa_ut_all.hesa_st_spau_id%TYPE := 0;
296: l_Qual_aim igs_he_code_map_val.map1%TYPE ;
297: l_rowid VARCHAR2(26) ;
298: C_st_spa_for_update cur_st_spa_for_update%ROWTYPE;
299: l_grade cur_highest_grade%ROWTYPE;
300: l_parent_awd_found BOOLEAN;