The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gsg.s_special_grade_type
FROM IGS_AS_SU_STMPTOUT suao,
IGS_AS_GRD_SCH_GRADE gsg
WHERE suao.person_id = p_person_id AND
suao.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
suao.uoo_id = p_uoo_id AND
suao.finalised_outcome_ind = 'Y' AND
suao.grading_schema_cd = gsg.grading_schema_cd AND
suao.version_number = gsg.version_number AND
suao.grade = gsg.grade AND
suao.outcome_dt IN (SELECT MAX(outcome_dt)
FROM IGS_AS_SU_STMPTOUT
WHERE person_id = suao.person_id AND
course_cd = suao.course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
uoo_id = suao.uoo_id);
SELECT sat.non_cntrl_exam_loc_cd
FROM IGS_AS_ASSESSMNT_ITM ai,
IGS_AS_ASSESSMNT_TYP atyp,
IGS_AS_SASSESS_TYPE sat
WHERE ai.ass_id = p_ass_id AND
atyp.assessment_type = ai.assessment_type AND
atyp.s_assessment_type = 'NONCENTRAL' AND
sat.s_assessment_type= atyp.s_assessment_type;
SELECT sua.location_cd,
sua.exam_location_cd,
um.s_unit_mode
FROM IGS_EN_SU_ATTEMPT sua,
IGS_AS_UNIT_CLASS ucl,
IGS_AS_UNIT_MODE um
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
ucl.unit_class = sua.unit_class AND
um.unit_mode = ucl.unit_mode AND
ucl.closed_ind = 'N';
SELECT exam_location_cd,
location_cd
FROM IGS_EN_STDNT_PS_ATT
WHERE person_id = p_person_id AND
course_cd = p_course_cd;
SELECT sut.transfer_course_cd
FROM IGS_PS_STDNT_UNT_TRN sut,
IGS_EN_SU_ATTEMPT sua
WHERE sut.person_id = cp_person_id AND
sua.person_id = sut.person_id AND
-- anilk, 22-Apr-2003, Bug# 2829262
sut.uoo_id = cp_uoo_id AND
sua.uoo_id = sut.uoo_id AND
sua.course_cd = sut.transfer_course_cd AND
sua.unit_attempt_status IN (cst_completed, cst_discontin)
ORDER BY sua.unit_attempt_status;
SELECT gsg.grading_schema_cd,
gsg.version_number,
gsg.grade,
gsg.s_result_type,
suao.translated_grading_schema_cd,
suao.translated_version_number,
suao.translated_grade
FROM IGS_AS_SU_STMPTOUT suao,
IGS_AS_GRD_SCH_GRADE gsg
WHERE suao.person_id = cp_person_id AND
suao.course_cd = c_v_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
suao.uoo_id = cp_uoo_id AND
suao.finalised_outcome_ind
LIKE DECODE(c_v_finalised_ind, 'Y', 'Y', '%') AND
suao.grading_schema_cd = gsg.grading_schema_cd AND
suao.version_number = gsg.version_number AND
suao.grade = gsg.grade
ORDER BY outcome_dt DESC; -- will put the newest date first.
SELECT gsg2.s_result_type
FROM IGS_AS_GRD_SCH_GRADE gsg2
WHERE gsg2.grading_schema_cd = v_suao_trans_grading_schema_cd AND
gsg2.version_number = v_suao_trans_version_number AND
gsg2.grade = v_suao_trans_grade;
SELECT gs.grading_schema_code grading_schema_code,
gs.grd_schm_version_number grd_schm_version_number
FROM igs_ps_usec_grd_schm_v gs,
igs_ps_unit_ofr_opt uoo
WHERE uoo.unit_cd = p_unit_cd
AND uoo.version_number = p_version_number
AND uoo.cal_type = p_cal_type
AND uoo.ci_sequence_number = p_ci_sequence_number
AND uoo.location_cd = p_location_cd
AND uoo.unit_class = p_unit_class
AND uoo.uoo_id = gs.uoo_id
AND gs.default_flag = 'Y';
SELECT gs.grading_schema_code grading_schema_code,
gs.grd_schm_version_number grd_schm_version_number
FROM igs_ps_unit_grd_schm_v gs
WHERE gs.unit_code = p_unit_cd
AND gs.unit_version_number = p_version_number
AND gs.default_flag = 'Y';
SELECT sut.transfer_course_cd , sua.unit_attempt_status
FROM IGS_PS_STDNT_UNT_TRN sut,
IGS_EN_SU_ATTEMPT sua
WHERE sut.person_id = p_person_id AND
sua.person_id = sut.person_id AND
-- anilk, 22-Apr-2003, Bug# 2829262
sut.uoo_id = p_uoo_id AND
sua.uoo_id = sut.uoo_id AND
sua.course_cd = sut.transfer_course_cd AND
sut.course_cd = cp_course_cd;
SELECT suao.outcome_dt,
suao.mark,
gsg.grading_schema_cd,
gsg.version_number,
gsg.grade,
gsg.s_result_type,
suao.translated_grading_schema_cd,
suao.translated_version_number,
suao.translated_grade,
suao.release_date
FROM IGS_AS_SU_STMPTOUT suao,
IGS_AS_GRD_SCH_GRADE gsg
WHERE suao.person_id = p_person_id AND
suao.course_cd = cp_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
suao.uoo_id = p_uoo_id AND
suao.finalised_outcome_ind LIKE cp_finalised_ind AND
suao.grading_schema_cd = gsg.grading_schema_cd AND
suao.version_number = gsg.version_number AND
suao.grade = gsg.grade
ORDER BY suao.outcome_dt DESC; -- will put the newest date first.
SELECT gsg2.s_result_type
FROM IGS_AS_GRD_SCH_GRADE gsg2
WHERE gsg2.grading_schema_cd = v_suao_trans_grading_schema_cd AND
gsg2.version_number = v_suao_trans_version_number AND
gsg2.grade = v_suao_trans_grade;
SELECT uoo_id
FROM igs_ps_unit_ofr_opt
WHERE unit_cd = p_unit_cd
AND version_number = p_version_number
AND cal_type = p_cal_type
AND ci_sequence_number = p_ci_sequence_number
AND location_cd = p_location_cd
AND unit_class = p_unit_class;
SELECT uai.cal_type
FROM IGS_AS_UNITASS_ITEM UAI,
IGS_AS_ASSESSMNT_ITM AI,
IGS_AS_ASSESSMNT_TYP ATP,
IGS_CA_INST CI,
IGS_CA_TYPE CAT,
IGS_CA_STAT CS
WHERE uai.unit_cd = p_unit_cd AND
uai.version_number = p_version_number AND
uai.cal_type = p_cal_type AND
uai.ci_sequence_number = p_ci_sequence_number AND
uai.ass_id = p_ass_id AND
IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
p_exam_cal_type,p_exam_ci_sequence_number,
ci.cal_type, ci.sequence_number,
'N') = 'Y'
and UAI.LOGICAL_DELETE_DT IS NULL AND
AI.ASS_ID = UAI.ASS_ID AND
AI.EXAM_SCHEDULED_IND = 'Y' AND
ATP.ASSESSMENT_TYPE = AI.ASSESSMENT_TYPE AND
ATP.EXAMINABLE_IND = 'Y' AND
CAT.CAL_TYPE = CI.CAL_TYPE AND
CAT.S_CAL_CAT = 'EXAM' AND
CS.CAL_STATUS = CI.CAL_STATUS AND
CS.S_CAL_STATUS = 'ACTIVE' AND
(UAI.EXAM_CAL_TYPE IS NULL OR
CI.CAL_TYPE = UAI.EXAM_CAL_TYPE) AND
(UAI.EXAM_CI_SEQUENCE_NUMBER IS NULL OR
CI.SEQUENCE_NUMBER = UAI.EXAM_CI_SEQUENCE_NUMBER) AND
IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(CI.CAL_TYPE,CI.SEQUENCE_NUMBER,
UAI.CAL_TYPE, UAI.CI_SEQUENCE_NUMBER, 'N') = 'Y';
SELECT supp_exam_permitted_ind
FROM IGS_PS_UNIT_VER
WHERE unit_cd = p_unit_cd AND
version_number = p_version_number;
SELECT usai.due_dt
FROM igs_en_su_attempt sua,
igs_ps_unitass_item usai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
usai.ass_id = p_ass_id AND
usai.logical_delete_dt IS NULL AND
sua.uoo_id = usai.uoo_id AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE';
SELECT usai.due_dt
FROM igs_en_su_attempt sua,
igs_ps_unitass_item usai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
usai.ass_id = p_ass_id AND
sua.uoo_id = usai.uoo_id AND
usai.logical_delete_dt = (
SELECT MAX(usai1.logical_delete_dt)
FROM igs_ps_unitass_item usai1
WHERE usai1.uoo_id = sua.uoo_id and
usai1.ass_id = usai.ass_id) AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE';
SELECT uai.due_dt
FROM IGS_EN_SU_ATTEMPT sua,
IGS_AS_UNITASS_ITEM uai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
uai.ass_id = p_ass_id AND
uai.logical_delete_dt IS NULL AND
sua.unit_cd = uai.unit_cd AND
sua.version_number = uai.version_number AND
sua.cal_type = uai.cal_type AND
sua.ci_sequence_number = uai.ci_sequence_number AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE';
SELECT uai.due_dt
FROM IGS_EN_SU_ATTEMPT sua,
IGS_AS_UNITASS_ITEM uai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
uai.ass_id = p_ass_id AND
uai.logical_delete_dt = (
SELECT MAX(uai1.logical_delete_dt)
FROM IGS_EN_SU_ATTEMPT sua1,
IGS_AS_UNITASS_ITEM uai1
WHERE sua1.person_id = sua.person_id AND
sua1.course_cd = sua.course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua1.uoo_id = sua.uoo_id AND
uai1.ass_id = uai.ass_id AND
sua.unit_cd = uai.unit_cd AND
sua.version_number = uai.version_number AND
sua.cal_type = uai.cal_type AND
sua.ci_sequence_number = uai.ci_sequence_number AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE'
);
SELECT usai.reference
FROM igs_en_su_attempt sua,
igs_ps_unitass_item usai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
usai.ass_id = p_ass_id AND
usai.logical_delete_dt IS NULL AND
sua.uoo_id = usai.uoo_id AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE';
SELECT usai.reference
FROM igs_en_su_attempt sua,
igs_ps_unitass_item usai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
usai.ass_id = p_ass_id AND
sua.uoo_id = usai.uoo_id AND
usai.logical_delete_dt = (
SELECT MAX(usai1.logical_delete_dt)
FROM igs_ps_unitass_item usai1
WHERE usai1.uoo_id = sua.uoo_id and
usai1.ass_id = usai.ass_id) AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE';
SELECT uai.reference
FROM IGS_EN_SU_ATTEMPT sua,
IGS_AS_UNITASS_ITEM uai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
uai.ass_id = p_ass_id AND
uai.logical_delete_dt IS NULL AND
sua.unit_cd = uai.unit_cd AND
sua.version_number = uai.version_number AND
sua.cal_type = uai.cal_type AND
sua.ci_sequence_number = uai.ci_sequence_number AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE';
SELECT uai.reference
FROM IGS_EN_SU_ATTEMPT sua,
IGS_AS_UNITASS_ITEM uai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
uai.ass_id = p_ass_id AND
uai.logical_delete_dt = (
SELECT MAX(uai1.logical_delete_dt)
FROM IGS_EN_SU_ATTEMPT sua1,
IGS_AS_UNITASS_ITEM uai1
WHERE sua1.person_id = sua.person_id AND
sua1.course_cd = sua.course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua1.uoo_id = sua.uoo_id AND
uai1.ass_id = uai.ass_id AND
sua.unit_cd = uai.unit_cd AND
sua.version_number = uai.version_number AND
sua.cal_type = uai.cal_type AND
sua.ci_sequence_number = uai.ci_sequence_number AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE'
);
SELECT 'x'
FROM IGS_PE_PERSID_GROUP pig,
IGS_PE_PRSID_GRP_MEM pigm
WHERE pig.group_cd = 'SPCL-NEEDS' AND
pig.closed_ind = 'N' AND
pig.group_id = pigm.group_id AND
pigm.person_id = p_person_id;
SELECT grading_schema_cd,
gs_version_number
FROM igs_as_appr_grd_sch
WHERE unit_cd = p_unit_cd AND
version_number = p_version_number AND
assessment_type = p_assessment_type AND
default_ind = 'Y' AND
closed_ind = 'N' ;
SELECT 'X'
FROM igs_as_appr_grd_sch
WHERE unit_cd = p_unit_cd AND
version_number = p_version_number AND
assessment_type = p_assessment_type AND
closed_ind = 'N';
SELECT description
FROM igs_as_grd_schema
WHERE grading_schema_cd = p_grading_schema_cd AND
version_number = p_gs_version_number;
SELECT uoo_id, version_number
FROM igs_en_su_attempt
WHERE person_id = p_person_id AND
course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
uoo_id = p_uoo_id;
SELECT grading_schema_cd, gs_version_number
FROM igs_ps_unitass_item
WHERE uoo_id = l_uoo_id AND
ass_id = p_ass_id AND
logical_delete_dt IS NULL;
SELECT grading_schema_cd, gs_version_number
FROM igs_as_unitass_item
WHERE unit_cd = p_unit_cd AND
version_number = l_version_number AND
cal_type = p_cal_type AND
ci_sequence_number = p_ci_sequence_number AND
ass_id = p_ass_id AND
logical_delete_dt IS NULL;
SELECT a.Course_cd, b.Title
FROM IGS_EN_STDNT_PS_ATT_ALL a, IGS_PS_VER_ALL b
WHERE a.course_cd = b.course_cd AND
a.version_number = b.version_number AND
a.course_attempt_status <> 'UNCONFIRM' AND
b.COURSE_TYPE = P_program_type AND
a.person_id = P_PERSON_ID /* AND
trunc(a.CREATION_DATE) <= (
SELECT min(trunc(innerpsatt.CREATION_DATE))
FROM IGS_EN_STDNT_PS_ATT_ALL innerpsatt, IGS_PS_VER_ALL innerpsver
WHERE innerpsatt.course_cd = innerpsver.course_cd AND
innerpsatt.version_number = innerpsver.version_number AND
innerpsatt.person_id = P_PERSON_ID AND
innerpsatt.course_attempt_status <> 'UNCONFIRM' AND
innerpsver.COURSE_TYPE = P_program_type
) */
ORDER BY COURSE_TYPE,primary_program_type ;
SELECT a.Course_cd, b.Title
FROM IGS_EN_STDNT_PS_ATT_ALL a, IGS_PS_VER_ALL b
WHERE a.course_cd = b.course_cd AND
a.version_number = b.version_number AND
a.course_attempt_status <> 'UNCONFIRM' AND
a.COMMENCEMENT_DT <= p_term_end_date AND
nvl(a.DISCONTINUED_DT , SYSDATE + 100000 ) >= p_term_start_date AND
b.COURSE_TYPE = (SELECT b.course_type
FROM IGS_EN_STDNT_PS_ATT_ALL innerpsatt, IGS_PS_VER_ALL innerpsver
WHERE innerpsatt.course_cd = innerpsver.course_cd AND
innerpsatt.version_number = innerpsver.version_number AND
innerpsatt.person_id = P_PERSON_ID AND
innerpsatt.course_cd = P_COURSE_CD) AND
a.person_id = P_PERSON_ID
ORDER BY primary_program_type ;
SELECT a.person_id ,a.Course_cd, c.Title
FROM IGS_PS_STDNT_TRN a, IGS_EN_STDNT_PS_ATT_ALL b , IGS_PS_VER c
WHERE a.COURSE_CD = b.course_cd AND
a.person_id = b.person_id AND
b.course_cd = c.course_cd AND
b.version_number = c.version_number AND
a.TRANSFER_COURSE_CD = P_program_cd AND
a.person_id = P_PERSON_ID;
SELECT a.course_cd, b.title
FROM igs_ps_stdnt_trn a, igs_ps_ver_all b , IGS_EN_STDNT_PS_ATT_ALL c
WHERE a.TRANSFER_COURSE_CD = c.course_cd
AND a.person_id = c.person_id
AND c.course_cd = b.course_cd
AND c.version_number = b.version_number
AND a.transfer_dt < p_term_end_date
AND a.transfer_dt > p_term_start_date
AND a.course_cd = p_program_cd
AND a.person_id = p_person_id;
* For selecting the current valid term
* Jitendra Handa
* Term Based Location display for VAH
******************************************************/
PROCEDURE get_current_term (
p_person_id IN NUMBER,
p_course_cd IN VARCHAR2,
p_cal_type OUT NOCOPY VARCHAR2,
p_seq_num OUT NOCOPY NUMBER
)
AS
CURSOR c_terms
IS
SELECT ci.cal_type, ci.sequence_number, ci.start_dt, ci.end_dt,
spa.person_id, spa.course_cd
FROM igs_en_stdnt_ps_att_all spa, igs_ca_inst ci,
igs_ps_ver_all pv
WHERE spa.course_attempt_status <> 'UNCONFIRM'
AND pv.course_cd = spa.course_cd
AND ci.start_dt <= SYSDATE
AND spa.person_id = p_person_id
AND spa.course_cd = p_course_cd
AND ( EXISTS (
SELECT 1
FROM igs_en_su_attempt_all sua,
igs_ca_teach_to_load_v ttl
WHERE sua.person_id = spa.person_id
AND sua.course_cd = spa.course_cd
AND sua.cal_type = ttl.teach_cal_type
AND sua.ci_sequence_number =
ttl.teach_ci_sequence_number
AND ttl.load_cal_type = ci.cal_type
AND ttl.load_ci_sequence_number = ci.sequence_number
AND sua.unit_attempt_status IN
('ENROLLED',
'COMPLETED',
'DISCONTIN',
'DUPLICATE'
))
OR EXISTS (
SELECT 1
FROM igs_av_stnd_unit asu
WHERE spa.person_id = asu.person_id
AND spa.course_cd = asu.as_course_cd
AND ci.cal_type = asu.cal_type
AND ci.sequence_number = asu.ci_sequence_number
AND asu.s_adv_stnd_granting_status = 'GRANTED')
OR EXISTS (
SELECT 1
FROM igs_av_stnd_unit_lvl asul
WHERE spa.person_id = asul.person_id
AND spa.course_cd = asul.as_course_cd
AND ci.cal_type = asul.cal_type
AND ci.sequence_number = asul.ci_sequence_number
AND asul.s_adv_stnd_granting_status = 'GRANTED')
)
ORDER BY ci.start_dt DESC;
SELECT sut.transfer_course_cd
FROM IGS_PS_STDNT_UNT_TRN sut,
IGS_EN_SU_ATTEMPT sua
WHERE sut.person_id = cp_person_id AND
sua.person_id = sut.person_id AND
sut.uoo_id = cp_uoo_id AND
sua.uoo_id = sut.uoo_id AND
sua.course_cd = sut.transfer_course_cd AND
sua.unit_attempt_status IN (cst_completed, cst_discontin)
ORDER BY sua.unit_attempt_status;
SELECT gsg.grading_schema_cd,
gsg.version_number,
gsg.grade,
gsg.s_result_type,
suao.translated_grading_schema_cd,
suao.translated_version_number,
suao.translated_grade
FROM IGS_AS_SU_STMPTOUT suao,
IGS_AS_GRD_SCH_GRADE gsg
WHERE suao.person_id = cp_person_id AND
suao.course_cd = c_v_course_cd AND
suao.uoo_id = cp_uoo_id AND
suao.finalised_outcome_ind
LIKE DECODE(c_v_finalised_ind, 'Y', 'Y', '%') AND
suao.grading_schema_cd = gsg.grading_schema_cd AND
suao.version_number = gsg.version_number AND
suao.grade = gsg.grade AND
nvl(suao.RELEASE_DATE ,sysdate+10) <=sysdate
ORDER BY outcome_dt DESC; -- will put the newest date first.
SELECT gsg2.s_result_type
FROM IGS_AS_GRD_SCH_GRADE gsg2
WHERE gsg2.grading_schema_cd = v_suao_trans_grading_schema_cd AND
gsg2.version_number = v_suao_trans_version_number AND
gsg2.grade = v_suao_trans_grade;
SELECT sut.transfer_course_cd
FROM IGS_PS_STDNT_UNT_TRN sut,
IGS_EN_SU_ATTEMPT sua
WHERE sut.person_id = cp_person_id AND
sua.person_id = sut.person_id AND
sut.uoo_id = cp_uoo_id AND
sua.uoo_id = sut.uoo_id AND
sua.course_cd = sut.transfer_course_cd AND
sua.unit_attempt_status IN (cst_completed, cst_discontin)
ORDER BY sua.unit_attempt_status;
SELECT gsg.grading_schema_cd,
gsg.version_number,
gsg.grade,
gsg.s_result_type,
suao.translated_grading_schema_cd,
suao.translated_version_number,
suao.translated_grade ,
suao.mark
FROM IGS_AS_SU_STMPTOUT suao,
IGS_AS_GRD_SCH_GRADE gsg
WHERE suao.person_id = cp_person_id AND
suao.course_cd = c_v_course_cd AND
suao.uoo_id = cp_uoo_id AND
suao.finalised_outcome_ind
LIKE DECODE(c_v_finalised_ind, 'Y', 'Y', '%') AND
suao.grading_schema_cd = gsg.grading_schema_cd AND
suao.version_number = gsg.version_number AND
suao.grade = gsg.grade AND
nvl(suao.RELEASE_DATE ,sysdate+10) <=sysdate
ORDER BY outcome_dt DESC; -- will put the newest date first.
SELECT gsg2.s_result_type
FROM IGS_AS_GRD_SCH_GRADE gsg2
WHERE gsg2.grading_schema_cd = v_suao_trans_grading_schema_cd AND
gsg2.version_number = v_suao_trans_version_number AND
gsg2.grade = v_suao_trans_grade;
SELECT reference, release_date
FROM igs_ps_unitass_item
WHERE unit_section_ass_item_id = usaid;
SELECT reference, release_date
FROM igs_as_unitass_item
WHERE unit_ass_item_id = uaid;
SELECT reference, release_date
FROM igs_ps_unitass_item
WHERE unit_section_ass_item_id = usaid;
SELECT reference, release_date
FROM igs_as_unitass_item
WHERE unit_ass_item_id = uaid;