APPS.IGS_AS_VAL_SUAO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 60

      SELECT  mark,
        grading_schema_cd,
        version_number,
        grade,
        finalised_outcome_ind,
        s_grade_creation_method_type
      FROM  IGS_AS_SU_STMPTOUT
      WHERE person_id     = cp_person_id AND
        course_cd     = cp_course_cd AND
                        -- anilk, 22-Apr-2003, Bug# 2829262
        uoo_id    = cp_uoo_id AND
        outcome_dt  = cp_outcome_dt;

Line: 169

      SELECT  unit_attempt_status
      FROM  IGS_EN_SU_ATTEMPT
      WHERE person_id = p_person_id AND
        course_cd = p_course_cd AND
                -- anilk, 22-Apr-2003, Bug# 2829262
        uoo_id    = p_uoo_id;

Line: 176

      SELECT  'x'
      FROM  IGS_AS_SU_STMPTOUT
      WHERE person_id = p_person_id and
        course_cd = p_course_cd and
                -- anilk, 22-Apr-2003, Bug# 2829262
        uoo_id          = p_uoo_id    and
        outcome_dt  <> p_outcome_dt and
        s_grade_creation_method_type = cst_discontin;

Line: 268

      SELECT 'x'
      FROM  IGS_AS_SU_STMPTOUT
      WHERE person_id = p_person_id AND
        course_cd = p_course_cd AND
                -- anilk, 22-Apr-2003, Bug# 2829262
        uoo_id          = p_uoo_id    AND
        outcome_dt  > p_outcome_dt;

Line: 309

      SELECT  closed_ind
      FROM  IGS_LOOKUPS_VIEW
      WHERE LOOKUP_TYPE  = p_s_grade_creation_method_type;

Line: 352

      SELECT gsg.lower_mark_range,
             gsg.upper_mark_range
      FROM   igs_as_grd_sch_grade gsg
      WHERE  gsg.grading_schema_cd = p_grading_schema_cd
      AND    gsg.version_number = p_version_number
      AND    gsg.grade = p_grade;

Line: 363

      SELECT NVL (MIN (gsg.lower_mark_range), 0) min_lower_mark_range,
             NVL (MAX (gsg.upper_mark_range), 1000) max_upper_mark_range
      FROM   igs_as_grd_sch_grade gsg
      WHERE  gsg.grading_schema_cd = p_grading_schema_cd
      AND    gsg.version_number = p_version_number;