APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 6211: l_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

6207: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
6208: l_grading_schema_cd igs_as_suaai_v.grading_schema_cd%TYPE;
6209: l_gs_version_number igs_as_suaai_v.gs_version_number%TYPE;
6210: l_grade igs_as_suaai_v.grade%TYPE;
6211: l_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
6212:
6213: BEGIN
6214:
6215: l_index := 1;

Line 7536: igs_he_st_spa spa1, igs_he_st_spa spa2, igs_as_grd_sch_grade gsg

7532: CURSOR c_unit_count IS
7533: SELECT count(*)
7534: FROM
7535: igs_en_su_attempt_all su, igs_as_su_stmptout_all suo1,
7536: igs_he_st_spa spa1, igs_he_st_spa spa2, igs_as_grd_sch_grade gsg
7537: WHERE su.person_id = suo1.person_id
7538: AND su.course_cd = suo1.course_cd
7539: AND su.unit_cd = suo1.unit_cd
7540: AND su.unit_attempt_status = 'COMPLETED'

Line 7884: igs_as_grd_sch_grade iagsg

7880: CURSOR c_welsh_bacc_pass_grd IS
7881: SELECT 'X'
7882: FROM igs_uc_qual_dets iuqd,
7883: igs_he_code_map_val ihcmv,
7884: igs_as_grd_sch_grade iagsg
7885: WHERE iuqd.person_id = p_person_id
7886: AND iuqd.exam_level = ihcmv.map2
7887: AND iuqd.grading_schema_cd = iagsg.grading_schema_cd
7888: AND iuqd.version_number = iagsg.version_number