APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_AS_SUAAI_V

Line 6126: -- smaddali replaced igs_as_suaai_v with igs_as_su_stmptout and added condition finalised_ind='Y' , Bug#2717755

6122: jbaber 19-Jan-06 Exclude flagged units for HE305 - Extract Improvements
6123: ***************************************************************/
6124:
6125: -- smaddali restructured the cursor for performance issue Bug#2839289
6126: -- smaddali replaced igs_as_suaai_v with igs_as_su_stmptout and added condition finalised_ind='Y' , Bug#2717755
6127: CURSOR c_mod IS
6128: SELECT DISTINCT a.unit_cd,
6129: a.version_number,
6130: d.prop_of_teaching_in_welsh,

Line 6208: l_grading_schema_cd igs_as_suaai_v.grading_schema_cd%TYPE;

6204:
6205:
6206: l_index NUMBER;
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:

Line 6209: l_gs_version_number igs_as_suaai_v.gs_version_number%TYPE;

6205:
6206: l_index NUMBER;
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

Line 6210: l_grade igs_as_suaai_v.grade%TYPE;

6206: l_index NUMBER;
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: