APPS.IGS_EN_RPT_PRC_UHK SQL Statements

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

Line: 107

      SELECT   unit_cd,
               version_number,
               cal_type,
               ci_sequence_number
      FROM     igs_ps_unit_ofr_opt
      WHERE    uoo_id = p_uoo_id;

Line: 123

  SELECT  sua.unit_cd,
          sua.version_number,
          sua.cal_type,
          sua.ci_sequence_number,
          sua.uoo_id,
          NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points))  override_enrolled_cp ,
          sua.course_cd
  FROM     igs_en_su_attempt sua,
           igs_ps_unit_ver uv,
           igs_ps_usec_cps cps
  WHERE    sua.person_id = p_person_id
  AND      sua.unit_cd = uv.unit_cd
  AND      sua.version_number = uv.version_number
  AND      sua.unit_cd = cp_unit_cd
  AND      sua.version_number = cp_version_number
  AND      sua.uoo_id = cps.uoo_id(+)
  AND      sua.unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM')
  AND      sua.cart IS NOT NULL;