APPS.IGS_AS_GEN_002 SQL Statements

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

Line: 13

        SELECT examinable_ind
        FROM   igs_as_assessmnt_typ
        WHERE  assessment_type = p_assessment_type;

Line: 53

        SELECT lr.sub_location_cd
        FROM   igs_ad_location_rel lr,
               igs_ad_location loc,
               igs_ad_location_type lt
        WHERE  lr.location_cd = p_location_cd
        AND    NVL (lr.dflt_ind, 'N') = 'Y'
        AND    NVL (loc.closed_ind, 'N') = 'N'
        AND    lt.s_location_type = 'EXAM_CTR'
        AND    loc.location_cd = lr.location_cd
        AND    loc.location_type = lt.location_type;

Line: 100

        SELECT   suao.finalised_outcome_ind
        FROM     igs_as_su_stmptout suao
        WHERE    suao.person_id = p_person_id
        AND      suao.course_cd = p_course_cd
        AND      suao.uoo_id = p_uoo_id
        ORDER BY suao.outcome_dt DESC;

Line: 134

        SELECT grade
        FROM   igs_as_grd_sch_grade
        WHERE  grading_schema_cd = p_grading_schema_cd
        AND    version_number = p_gs_version_number
        AND    (lower_mark_range IS NOT NULL
                OR upper_mark_range IS NOT NULL
               )
        AND    NVL (lower_mark_range, 0) <= FLOOR (p_mark)
        AND    NVL (upper_mark_range, 1000) >= FLOOR (p_mark)
        AND    NVL (closed_ind, 'N') = 'N';

Line: 237

        SELECT gsg.s_special_grade_type
        FROM   igs_as_grd_sch_grade gsg
        WHERE  gsg.grading_schema_cd = p_grading_schema_cd
        AND    gsg.version_number = p_version_number
        AND    gsg.grade = p_grade;

Line: 280

        SELECT gsg.RANK
        FROM   igs_as_grd_sch_grade gsg
        WHERE  gsg.grading_schema_cd = p_grading_schema_cd
        AND    gsg.version_number = p_version_number
        AND    gsg.grade = p_grade;

Line: 317

        SELECT gsg.s_result_type
        FROM   igs_as_grd_sch_grade gsg
        WHERE  gsg.grading_schema_cd = p_grading_schema_cd
        AND    gsg.version_number = p_version_number
        AND    gsg.grade = p_grade;

Line: 353

        SELECT lower_mark_range,
               upper_mark_range
        FROM   igs_as_grd_sch_grade
        WHERE  grading_schema_cd = p_grading_schema_cd
        AND    version_number = p_version_number
        AND    grade = p_grade;

Line: 396

        SELECT s_assessment_type
        FROM   igs_as_assessmnt_typ atyp,
               igs_as_assessmnt_itm ai
        WHERE  ai.ass_id = cp_ass_id
        AND    ai.assessment_type = atyp.assessment_type;