APPS.IGS_GR_VAL_AWC SQL Statements

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

Line: 21

      SELECT  s_award_type
      FROM  IGS_PS_AWD
      WHERE award_cd = p_award_cd;

Line: 82

      SELECT  'X'
      FROM  IGS_EN_STDNT_PS_ATT sca
      WHERE sca.course_cd   = p_course_cd AND
        sca.version_number  = p_version_number;

Line: 118

      SELECT closed_ind
      FROM   IGS_PS_AWD aw
      WHERE  aw.award_cd = p_award_cd;

Line: 171

      SELECT  'X'
      FROM  IGS_GR_AWD_CEREMONY awc
      WHERE awc.grd_cal_type    = p_grd_cal_type AND
        awc.grd_ci_sequence_number  = p_grd_ci_sequence_number AND
        awc.ceremony_number   = p_ceremony_number AND
        awc.order_in_ceremony   = p_order_in_ceremony AND
        awc.award_cd      <> p_award_cd;

Line: 179

      SELECT  acusg.grd_cal_type,
        acusg.grd_ci_sequence_number,
        acusg.ceremony_number,
        acusg.award_course_cd,
        acusg.award_crs_version_number,
        acusg.award_cd,
        acusg.us_group_number
      FROM  IGS_GR_AWD_CRM_US_GP  acusg
      WHERE acusg.grd_cal_type    = p_grd_cal_type AND
        acusg.grd_ci_sequence_number  = p_grd_ci_sequence_number AND
        acusg.ceremony_number   = p_ceremony_number AND
        acusg.award_course_cd   = p_award_course_cd AND
        acusg.award_crs_version_number  = p_award_crs_version_number AND
        acusg.award_cd      = p_award_cd;

Line: 276

      SELECT  'x'
      FROM  IGS_GR_AWD_CEREMONY awc1,
        IGS_GR_AWD_CEREMONY awc2,
        IGS_GR_AWD_CRM_US_GP  acusg1,
        IGS_GR_AWD_CRM_US_GP  acusg2
      WHERE acusg1.grd_cal_type   = p_grd_cal_type AND
        acusg1.grd_ci_sequence_number = p_grd_ci_sequence_number AND
        acusg1.ceremony_number    = p_ceremony_number AND
        acusg1.award_course_cd    = p_award_course_cd AND
        acusg1.award_crs_version_number = p_award_crs_version_number AND
        acusg1.award_cd     = p_award_cd AND
        acusg1.us_group_number    = p_us_group_number AND
        acusg1.closed_ind       = 'N' AND
        acusg2.grd_cal_type   = acusg1.grd_cal_type AND
        acusg2.grd_ci_sequence_number = acusg1.grd_ci_sequence_number AND
        acusg2.ceremony_number    = acusg1.ceremony_number AND
        (acusg2.award_course_cd   <> acusg1.award_course_cd OR
        acusg2.award_crs_version_number <> acusg1.award_crs_version_number) AND
        acusg2.award_cd     = acusg1.award_cd AND
        acusg2.closed_ind       = 'N' AND
        acusg1.order_in_award   = acusg2.order_in_award AND
        awc1.grd_cal_type     = acusg1.grd_cal_type AND
        awc1.grd_ci_sequence_number = acusg1.grd_ci_sequence_number AND
        awc1.ceremony_number    = acusg1.ceremony_number AND
        awc1.award_course_cd    = acusg1.award_course_cd AND
        awc1.award_crs_version_number = acusg1.award_crs_version_number AND
        awc1.award_cd     = acusg1.award_cd AND
        awc1.closed_ind     = 'N' AND
        awc2.grd_cal_type     = acusg2.grd_cal_type AND
        awc2.grd_ci_sequence_number = acusg2.grd_ci_sequence_number AND
        awc2.ceremony_number    = acusg2.ceremony_number AND
        awc2.award_course_cd    = acusg2.award_course_cd AND
        awc2.award_crs_version_number = acusg2.award_crs_version_number AND
        awc2.award_cd     = acusg2.award_cd AND
        awc2.closed_ind     = 'N' AND
        awc1.order_in_ceremony    = awc2.order_in_ceremony
      AND
      (EXISTS
        (SELECT acus.unit_set_cd,
          acus.us_version_number
        FROM  IGS_GR_AWD_CRM_UT_ST  acus
        WHERE acus.grd_cal_type     = acusg1.grd_cal_type AND
          acus.grd_ci_sequence_number = acusg1.grd_ci_sequence_number AND
          acus.ceremony_number    = acusg1.ceremony_number AND
          acus.award_course_cd    = acusg1.award_course_cd AND
          acus.award_crs_version_number = acusg1.award_crs_version_number AND
          acus.award_cd     = acusg1.award_cd AND
          acus.us_group_number    = acusg1.us_group_number
        MINUS
          SELECT  acus.unit_set_cd,
            acus.us_version_number
          FROM  IGS_GR_AWD_CRM_UT_ST  acus
          WHERE acus.grd_cal_type     = acusg2.grd_cal_type AND
            acus.grd_ci_sequence_number = acusg2.grd_ci_sequence_number AND
            acus.ceremony_number    = acusg2.ceremony_number AND
            acus.award_course_cd    = acusg2.award_course_cd AND
            acus.award_crs_version_number = acusg2.award_crs_version_number AND
            acus.award_cd     = acusg2.award_cd AND
            acus.us_group_number    = acusg2.us_group_number)
      OR
      EXISTS
        (SELECT acus.unit_set_cd,
          acus.us_version_number
        FROM  IGS_GR_AWD_CRM_UT_ST  acus
        WHERE acus.grd_cal_type     = acusg2.grd_cal_type AND
          acus.grd_ci_sequence_number = acusg2.grd_ci_sequence_number AND
          acus.ceremony_number    = acusg2.ceremony_number AND
          acus.award_course_cd    = acusg2.award_course_cd AND
          acus.award_crs_version_number = acusg2.award_crs_version_number AND
          acus.award_cd     = acusg2.award_cd AND
          acus.us_group_number    = acusg2.us_group_number
        MINUS
          SELECT  acus.unit_set_cd,
            acus.us_version_number
          FROM  IGS_GR_AWD_CRM_UT_ST  acus
          WHERE acus.grd_cal_type     = acusg1.grd_cal_type AND
            acus.grd_ci_sequence_number = acusg1.grd_ci_sequence_number AND
            acus.ceremony_number    = acusg1.ceremony_number AND
            acus.award_course_cd    = acusg1.award_course_cd AND
            acus.award_crs_version_number = acusg1.award_crs_version_number AND
            acus.award_cd     = acusg1.award_cd AND
            acus.us_group_number    = acusg1.us_group_number)
      );