eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_IMPORT_DATA dependencies on IGS_HE_CODE_VALUES

Line 17: l_oss_fee_elig igs_he_code_values.value%TYPE ;

13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;
14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;
15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;
16: l_oss_disability igs_he_code_map_val.map2%TYPE ;
17: l_oss_fee_elig igs_he_code_values.value%TYPE ;
18: l_oss_inst igs_or_org_alt_ids.org_structure_id%TYPE ;
19: l_oss_social_class igs_he_code_map_val.map2%TYPE ;
20: l_batch_id igs_he_ucas_imp_err.batch_id%TYPE ;
21: l_error_flag BOOLEAN ;

Line 1228: EXISTS( SELECT 'X' FROM igs_he_code_values

1224: CURSOR c_high_qual( cp_high_qual igs_as_grd_sch_grade.grade%TYPE ) IS
1225: SELECT grade
1226: FROM igs_as_grd_sch_grade gsg
1227: WHERE
1228: EXISTS( SELECT 'X' FROM igs_he_code_values
1229: WHERE code_type = 'HESA_HIGH_QUAL_ON_ENT' AND
1230: value = gsg.grading_schema_cd AND
1231: NVL(closed_ind,'N' ) = 'N' )
1232: AND gsg.grade= cp_high_qual