APPS.IGS_PR_GEN_002 SQL Statements

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

Line: 106

    SELECT  version_number,
      location_cd,
      unit_class,
      unit_attempt_status
    FROM  IGS_EN_SU_ATTEMPT   sua
    WHERE sua.person_id     = p_person_id AND
      sua.course_cd     = p_course_cd AND
      sua.uoo_id = p_uoo_id;

Line: 119

    SELECT  gsg.gpa_val
    FROM  IGS_AS_GRD_SCH_GRADE    gsg
    WHERE gsg.grading_schema_cd   = cp_grading_schema_cd AND
      gsg.version_number    = cp_version_number AND
      gsg.grade     = cp_grade;

Line: 147

      SELECT  MAX(gsg.gpa_val),
        MIN(gsg.gpa_val)
      FROM  IGS_AS_GRD_SCH_GRADE  gsg
      WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND
        gsg.version_number  = cp_version_number AND
        gsg.gpa_val   IS NOT NULL;

Line: 309

    SELECT  sca.version_number
    FROM  IGS_EN_STDNT_PS_ATT sca
    WHERE sca.person_id   = p_person_id AND
      sca.course_cd   = p_course_cd;

Line: 315

    SELECT  ci1.cal_type,
      ci1.sequence_number
    FROM  IGS_CA_TYPE     cat,
      IGS_CA_STAT   cs,
      IGS_CA_INST     ci1
    WHERE cat.cal_type    = ci1.cal_type AND
      cat.s_cal_cat   = cst_progress AND
      cs.cal_status   = ci1.cal_status AND
      cs.s_cal_status   = cst_active AND
      IGS_PR_GEN_001.prgp_get_cal_stream (
            p_course_cd,
            cp_version_number,
            p_prg_cal_type,
            ci1.cal_type)
            = 'Y' AND
      ci1.start_dt    <
      (SELECT ci2.start_dt
      FROM  IGS_CA_INST   ci2
      WHERE ci2.cal_type    = p_prg_cal_type AND
        ci2.sequence_number = p_prg_sequence_number)
    ORDER BY ci1.start_dt DESC;

Line: 475

    SELECT  'X'
    FROM  IGS_CA_INST_REL cir
    WHERE cir.sub_cal_type    = p_cal_type AND
      cir.sub_ci_sequence_number  = p_ci_sequence_number AND
      cir.sup_cal_type    = p_prg_cal_type AND
      cir.sup_ci_sequence_number  = p_prg_ci_sequence_number;

Line: 486

    SELECT  sua.discontinued_dt,
      sua.unit_attempt_status
    FROM  IGS_EN_SU_ATTEMPT   sua
    WHERE sua.person_id     = p_person_id AND
      sua.course_cd     = p_course_cd AND
      sua.uoo_id = p_uoo_id;

Line: 493

    SELECT  sca.version_number
    FROM  IGS_EN_STDNT_PS_ATT     sca
    WHERE sca.person_id     = p_person_id AND
      sca.course_cd     = p_course_cd;

Line: 499

    SELECT  cir.sup_cal_type,
      cir.sup_ci_sequence_number
    FROM  IGS_CA_INST     ci1,
      IGS_CA_INST_REL   cir,
      IGS_CA_TYPE       ct,
      IGS_CA_STAT     cs
    WHERE cir.sub_cal_type      = p_cal_type AND
      cir.sub_ci_sequence_number  = p_ci_sequence_number AND
      ct.cal_type     = cir.sup_cal_type AND
      ct.s_cal_cat      = cst_progress AND
      ci1.cal_type      = cir.sup_cal_type AND
      ci1.sequence_number   = cir.sup_ci_sequence_number AND
      cs.cal_status     = ci1.cal_status AND
      cs.s_cal_status     = cst_active AND
      IGS_PR_GEN_001.prgp_get_cal_stream (
        p_course_cd,
        cp_sca_version_number,
        p_prg_cal_type,
        cir.sup_cal_type)   = 'Y' AND
      ci1.start_dt      <
      (SELECT ci2.start_dt
      FROM  IGS_CA_INST     ci2
      WHERE ci2.cal_type      = p_prg_cal_type AND
        ci2.sequence_number   = p_prg_ci_sequence_number)
    ORDER BY ci1.start_dt DESC;

Line: 526

    SELECT  'X'
    FROM  IGS_CA_INST     ci1,
      IGS_CA_INST_REL   cir,
      IGS_CA_TYPE       ct,
      IGS_CA_STAT     cs
    WHERE cir.sub_cal_type      = p_cal_type AND
      cir.sub_ci_sequence_number  = p_ci_sequence_number AND
      ct.cal_type     = cir.sup_cal_type AND
      ct.s_cal_cat      = cst_progress AND
      ci1.cal_type      = cir.sup_cal_type AND
      ci1.sequence_number   = cir.sup_ci_sequence_number AND
      cs.cal_status     = ci1.cal_status AND
      cs.s_cal_status     = cst_active AND
      IGS_PR_GEN_001.prgp_get_cal_stream (
        p_course_cd,
        cp_sca_version_number,
        p_prg_cal_type,
        cir.sup_cal_type)   = 'Y' AND
      ci1.start_dt      >
      (SELECT ci2.start_dt
      FROM  IGS_CA_INST     ci2
      WHERE ci2.cal_type      = p_prg_cal_type AND
        ci2.sequence_number   = p_prg_ci_sequence_number);

Line: 744

    SELECT  sua.unit_attempt_status,sua.administrative_unit_status
    FROM  IGS_EN_SU_ATTEMPT sua
    WHERE sua.person_id   = p_person_id AND
      sua.course_cd   = p_course_cd AND
      sua.uoo_id = p_uoo_id;

Line: 751

    SELECT effective_progression_ind
    FROM   IGS_AD_ADM_UNIT_STAT
    WHERE  administrative_unit_status=cp_administrative_unit_status;