APPS.IGS_RU_VAL_UNIT_RULE SQL Statements

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

Line: 14

    SELECT s_rule_call_cd , rul_sequence_number
    FROM igs_ps_usec_ru
    WHERE uoo_id = cp_uoo_id
    AND s_rule_call_cd = cp_rul_call_cd;

Line: 23

    SELECT s_rule_call_cd , rul_sequence_number
    FROM igs_ps_unit_ver_ru
    WHERE unit_cd = cp_unit_cd
    AND version_number = cp_version_number
    AND s_rule_call_cd = cp_rul_call_cd;

Line: 31

    SELECT ps.course_cd , ps.version_number
    FROM igs_en_stdnt_ps_att ps
    WHERE ps.person_id = cp_person_id
    AND  ps.course_attempt_status IN ('ENROLLED' ,'INACTIVE')
    AND  EXISTS ( SELECT 1 FROM igs_en_su_attempt su
         WHERE  su.person_id=ps.person_id
         AND su.course_cd =ps.course_cd  )
    ORDER BY  course_cd desc;

Line: 43

        SELECT    cv.load_cal_type ,
                  cv.load_ci_sequence_number
        FROM      igs_ca_teach_to_load_v cv,
                  IGS_CA_INST ci,
                  IGS_CA_STAT cs
        WHERE     cv.teach_cal_type           =  cp_teach_cal_type
        AND       cv.teach_ci_sequence_number =  cp_teach_ci_sequence_number
        AND       ci.cal_type = cv.load_cal_type
        AND       ci.sequence_number = cv.load_ci_sequence_number
        AND       ci.cal_status = cs.cal_status
        AND       cs.s_cal_status = cst_active
        ORDER BY  load_start_dt ASC;