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_AS_GRD_SCH_GRADE

Line 1224: CURSOR c_high_qual( cp_high_qual igs_as_grd_sch_grade.grade%TYPE ) IS

1220: -- get the oss code for highest qualification on entry field
1221: -- smaddali modified this cursor for bug 2726086 to compare highest_qual to grade instead of rank
1222: -- smaddali modified cursor topget onlyopen code values , bug 2730388
1223: -- modified the cursor replace the equal comparision with EXISTS for bug, 3463819
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

Line 1226: FROM igs_as_grd_sch_grade gsg

1222: -- smaddali modified cursor topget onlyopen code values , bug 2730388
1223: -- modified the cursor replace the equal comparision with EXISTS for bug, 3463819
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