The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT grade,
lower_mark_range,
upper_mark_range
FROM igs_as_grd_sch_grade
WHERE grading_schema_cd = cp_grading_schema_cd
AND version_number = cp_version_number
AND s_result_type IN ('FAIL', 'PASS')
AND NVL (admin_only_ind, 'N') <> 'Y'
AND NVL (closed_ind, 'N') <> 'Y'
ORDER BY lower_mark_range ASC;
SELECT grading_schema_code,
grd_schm_version_number
FROM igs_ps_usec_grd_schm
WHERE uoo_id = cp_uoo_id
AND default_flag = 'Y';
SELECT ugs.grading_schema_code,
ugs.grd_schm_version_number
FROM igs_ps_unit_grd_schm ugs,
igs_ps_unit_ofr_opt_all uoo
WHERE uoo.uoo_id = cp_uoo_id
AND ugs.unit_code = uoo.unit_cd
AND ugs.unit_version_number = uoo.version_number
AND ugs.default_flag = 'Y';
SELECT DISTINCT grading_schema_cd,
gs_version_number
FROM igs_as_su_atmpt_itm
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd
AND uoo_id = cp_uoo_id
AND logical_delete_dt IS NULL
AND grading_schema_cd IS NOT NULL;
SELECT suai.ass_id ass_id,
suai.unit_ass_item_id,
suai.unit_section_ass_item_id
FROM igs_as_su_atmpt_itm suai
WHERE suai.person_id = cp_person_id
AND suai.course_cd = cp_course_cd
AND suai.uoo_id = cp_uoo_id
AND suai.grading_schema_cd = cp_grading_schema_cd
AND suai.gs_version_number = cp_gs_version_number;
SELECT uai.reference
FROM igs_as_unitass_item_all uai
WHERE uai.unit_ass_item_id = cp_unit_ass_item_id;
SELECT usai.reference
FROM igs_ps_unitass_item usai
WHERE usai.unit_section_ass_item_id = cp_unit_section_ass_item_id;
SELECT suag.group_name,
DECODE (cp_grading_period_cd,
'FINAL', suag.final_formula_code,
'MIDTERM', suag.midterm_formula_code) group_formula_code,
DECODE (cp_grading_period_cd,
'FINAL', suag.final_formula_qty,
'MIDTERM', suag.midterm_formula_qty) group_formula_qty,
DECODE (cp_grading_period_cd,
'FINAL', suag.final_weight_qty,
'MIDTERM', suag.midterm_weight_qty) group_weight_qty,
suai.ass_id,
suai.grading_schema_cd,
suai.gs_version_number,
DECODE (cp_grading_period_cd,
'FINAL', suai.final_mandatory_type_code,
'MIDTERM', suai.midterm_mandatory_type_code) mandatory_type_code,
DECODE (cp_grading_period_cd,
'FINAL', suai.final_weight_qty,
'MIDTERM', suai.midterm_weight_qty) ai_weight_qty,
NVL (suai.waived_flag, 'N') waived_flag,
suai.mark,
(suai.mark - gslu.lower_limit) *
(100 / (gslu.upper_limit - gslu.lower_limit)) common_base_mark
FROM igs_as_sua_ai_group suag,
igs_as_su_atmpt_itm suai,
(SELECT grading_schema_cd,
version_number,
MIN (lower_mark_range) lower_limit,
MAX (upper_mark_range) upper_limit
FROM igs_as_grd_sch_grade
GROUP BY grading_schema_cd,
version_number) gslu
WHERE suag.person_id = cp_person_id
AND suag.course_cd = cp_course_cd
AND suag.uoo_id = cp_uoo_id
AND suag.logical_delete_date IS NULL
AND suai.logical_delete_dt IS NULL
AND DECODE (cp_grading_period_cd,
'FINAL', suag.final_formula_code,
'MIDTERM', suag.midterm_formula_code) IS NOT NULL
AND DECODE (cp_grading_period_cd,
'FINAL', suag.final_weight_qty,
'MIDTERM', suag.midterm_weight_qty) > 0
AND DECODE (cp_grading_period_cd,
'FINAL', suai.final_mandatory_type_code,
'MIDTERM', suai.midterm_mandatory_type_code) IS NOT NULL
AND DECODE (suai.waived_flag,
'Y', 1,
NVL (DECODE (cp_grading_period_cd,
'FINAL', suai.final_weight_qty,
'MIDTERM', suai.midterm_weight_qty), 0)) > 0
AND suag.sua_ass_item_group_id = suai.sua_ass_item_group_id
AND suai.grading_schema_cd = gslu.grading_schema_cd (+)
AND suai.gs_version_number = gslu.version_number (+)
ORDER BY suag.group_name ASC, common_base_mark DESC;
SELECT usgs.grading_schema_code,
usgs.grd_schm_version_number,
gslu.lower_limit,
gslu.upper_limit
FROM igs_ps_usec_grd_schm usgs,
(SELECT grading_schema_cd,
version_number,
MIN (lower_mark_range) lower_limit,
MAX (upper_mark_range) upper_limit
FROM igs_as_grd_sch_grade
GROUP BY grading_schema_cd,
version_number) gslu
WHERE usgs.uoo_id = cp_uoo_id
AND usgs.default_flag = 'Y'
AND usgs.grading_schema_code = gslu.grading_schema_cd
AND usgs.grd_schm_version_number = gslu.version_number;
SELECT ugs.grading_schema_code,
ugs.grd_schm_version_number,
gslu.lower_limit,
gslu.upper_limit
FROM igs_ps_unit_grd_schm ugs,
igs_ps_unit_ofr_opt_all uoo,
(SELECT grading_schema_cd,
version_number,
MIN (lower_mark_range) lower_limit,
MAX (upper_mark_range) upper_limit
FROM igs_as_grd_sch_grade
GROUP BY grading_schema_cd,
version_number) gslu
WHERE uoo.uoo_id = cp_uoo_id
AND ugs.unit_code = uoo.unit_cd
AND ugs.unit_version_number = uoo.version_number
AND ugs.default_flag = 'Y'
AND ugs.grading_schema_code = gslu.grading_schema_cd
AND ugs.grd_schm_version_number = gslu.version_number;
SELECT grade,
s_result_type
FROM igs_as_grd_sch_grade
WHERE grading_schema_cd = cp_grading_schema_code
AND version_number = cp_grading_schema_version
AND cp_mark BETWEEN lower_mark_range AND upper_mark_range;
SELECT key_mark_entry_dec_points
FROM igs_as_entry_conf
WHERE s_control_num = 1;
g_module_head || l_routine || '.selected values',
'group_name =>' || rec_suaaig.group_name || ';' ||
SELECT 'Y' submitted
FROM igs_as_gaa_sub_hist sub
WHERE sub.uoo_id = p_uoo_id
AND sub.grading_period_cd = p_grading_period_cd
AND sub.submission_type = 'GRADE'
AND sub.submission_status = 'COMPLETE';
SELECT 'Y' finalized_manually_overridden
FROM igs_as_su_stmptout_all suao
WHERE suao.person_id = p_person_id
AND suao.course_cd = p_course_cd
AND suao.uoo_id = p_uoo_id
AND suao.grading_period_cd = p_grading_period_cd
AND suao.outcome_dt =
(SELECT MAX (outcome_dt)
FROM igs_as_su_stmptout_all
WHERE person_id = suao.person_id
AND course_cd = suao.course_cd
AND uoo_id = suao.uoo_id
AND grading_period_cd = suao.grading_period_cd)
AND (suao.manual_override_flag = 'Y'
OR suao.finalised_outcome_ind = 'Y');
SELECT 'Y' submitted
FROM igs_as_gaa_sub_hist sub
WHERE sub.uoo_id = p_uoo_id
AND sub.grading_period_cd = p_grading_period_cd
AND sub.submission_type = 'GRADE'
AND sub.submission_status = 'COMPLETE';
SELECT 'Y' finalized_manually_overridden
FROM igs_as_su_stmptout_all suao
WHERE suao.person_id = p_person_id
AND suao.course_cd = p_course_cd
AND suao.uoo_id = p_uoo_id
AND suao.grading_period_cd = p_grading_period_cd
AND suao.outcome_dt =
(SELECT MAX (outcome_dt)
FROM igs_as_su_stmptout_all
WHERE person_id = suao.person_id
AND course_cd = suao.course_cd
AND uoo_id = suao.uoo_id
AND grading_period_cd = suao.grading_period_cd)
AND (suao.manual_override_flag = 'Y'
OR suao.finalised_outcome_ind = 'Y');
SELECT DISTINCT suao.person_id,
suao.course_cd,
suao.unit_cd,
suao.ci_start_dt
FROM igs_as_su_stmptout_all suao,
igs_en_su_attempt_all sua
WHERE suao.person_id = sua.person_id
AND suao.course_cd = sua.course_cd
AND suao.uoo_id = sua.uoo_id
AND sua.unit_attempt_status <> 'DROPPED'
AND suao.uoo_id <> p_uoo_id
AND suao.unit_cd = cp_unit_cd
AND suao.course_cd = cp_course_cd
AND suao.person_id = cp_person_id
ORDER BY suao.ci_start_dt ASC;
SELECT start_dt
FROM igs_ca_inst ci,
igs_ps_unit_ofr_opt_all uoo
WHERE uoo.cal_type = ci.cal_type
AND ci.sequence_number = uoo.ci_sequence_number
AND uoo.uoo_id = cp_uoo_id;
SELECT acc.mid_mgs_start_dt_alias,
acc.mid_mgs_end_dt_alias,
acc.efinal_mgs_start_dt_alias,
acc.efinal_mgs_end_dt_alias,
acc.final_mgs_start_dt_alias,
acc.final_mgs_end_dt_alias
FROM igs_as_cal_conf acc
WHERE s_control_num = 1;
SELECT 'Y'
FROM igs_ca_da_inst_v dai1,
igs_ca_da_inst_v dai2
WHERE dai1.alias_val >= TRUNC (SYSDATE)
AND dai2.alias_val <= TRUNC (SYSDATE)
AND dai1.cal_type = dai2.cal_type
AND dai1.ci_sequence_number = dai2.ci_sequence_number
AND dai1.cal_type = cp_teach_cal_type
AND dai1.ci_sequence_number = cp_teach_ci_sequence_number
AND dai2.dt_alias = cp_start_date_alias
AND dai1.dt_alias = cp_end_date_alias;