[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x'
FROM IGS_AS_SU_SETATMPT susa
WHERE susa.person_id = p_person_id AND
susa.course_cd = p_course_cd AND
susa.student_confirmed_ind = 'Y' AND
susa.rqrmnts_complete_ind = 'N' AND
susa.end_dt IS NULL;
SELECT sca.course_attempt_status
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id And
sca.course_cd = p_course_cd And
sca.course_attempt_status = cst_unconfirm;
SELECT gr.graduand_status
FROM IGS_GR_GRADUAND gr,
IGS_GR_STAT gst
WHERE gr.person_id = p_person_id AND
gr.course_cd = p_course_cd AND
gr.award_course_cd = p_course_cd AND
gr.award_crs_version_number = p_version_number AND
gr.graduand_status = gst.graduand_status AND
gst.s_graduand_status IN (
cst_graduated,
cst_surrender);
SELECT gr.graduand_status
FROM IGS_GR_GRADUAND gr,
IGS_GR_STAT gst
WHERE gr.person_id = p_person_id AND
gr.course_cd = p_course_cd AND
gr.award_course_cd = p_exit_course_cd AND
gr.award_crs_version_number = p_exit_version_number AND
gr.graduand_status = gst.graduand_status AND
gst.s_graduand_status IN (
cst_graduated,
cst_surrender);
SELECT 'X'
FROM IGS_PS_STDNT_APV_ALT scaae
WHERE scaae.person_id = p_person_id AND
scaae.course_cd = p_course_cd AND
scaae.rqrmnts_complete_ind = 'Y';
SELECT 'X'
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_course_cd AND
sca.course_rqrmnt_complete_ind = 'Y';
SELECT MAX(suaov.outcome_dt)
FROM IGS_AS_SUAO_V suaov
WHERE suaov.person_id = p_person_id AND
suaov.course_cd = p_course_cd AND
suaov.finalised_outcome_ind = 'Y';