APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_UC_QUAL_DETS

Line 6707: FROM igs_uc_qual_dets a

6703:
6704: -- smaddali selecting grading_schema_cd for HECR210 build
6705: CURSOR c_pgce_cls IS
6706: SELECT a.approved_result, a.grading_schema_cd
6707: FROM igs_uc_qual_dets a
6708: WHERE a.person_id = p_person_id
6709: AND EXISTS (SELECT 'X'
6710: FROM igs_he_code_values b
6711: WHERE b.value = a.exam_level

Line 6718: l_grading_schema igs_uc_qual_dets.grading_schema_cd%TYPE;

6714: ORDER BY a.year DESC;
6715:
6716: l_pgce_class igs_he_code_map_val.map1%TYPE;
6717: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
6718: l_grading_schema igs_uc_qual_dets.grading_schema_cd%TYPE;
6719:
6720: BEGIN
6721:
6722: OPEN c_pgce_cls ;

Line 7873: FROM igs_uc_qual_dets iuqd,

7869: ******************************************************************************/
7870:
7871: CURSOR c_welsh_bacc_qual IS
7872: SELECT 'X'
7873: FROM igs_uc_qual_dets iuqd,
7874: igs_he_code_map_val ihcmv
7875: WHERE iuqd.person_id = p_person_id
7876: AND ihcmv.association_code = 'UCAS_OSS_AWD_ASSOC'
7877: AND ihcmv.map1 = 'WB'

Line 7882: FROM igs_uc_qual_dets iuqd,

7878: AND ihcmv.map2 = iuqd.exam_level;
7879:
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