APPS.IGS_AS_VAL_EI SQL Statements

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

Line: 30

                SELECT  atyp.examinable_ind,
                        ai.exam_scheduled_ind
                FROM    IGS_AS_ASSESSMNT_TYP         atyp,
                        IGS_AS_ASSESSMNT_ITM         ai
                WHERE   ai.ass_id               = p_ass_id      AND
                        atyp.assessment_type    = ai.assessment_type;

Line: 38

                SELECT  ust.s_unit_status
                FROM    IGS_PS_UNIT_STAT             ust,
                        IGS_AS_UNITASS_ITEM    uai,
                        IGS_PS_UNIT_VER            uv
                WHERE   uai.ass_id                              = p_ass_id              AND
                        IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
                                        p_exam_cal_type,
                                        p_exam_ci_sequence_number,
                                        uai.cal_type,
                                        uai.ci_sequence_number,
                                        'N')                    = 'Y'                   AND
                        uv.unit_cd                              = uai.unit_cd           AND
                        uv.version_number                       = uai.version_number    AND
                        ust.unit_status                         = uv.unit_status;