The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT deceased_ind
FROM IGS_PE_PERSON
WHERE person_id = p_person_id;
SELECT thes.final_title_ind
FROM IGS_RE_THESIS thes
WHERE thes.person_id = p_person_id AND
thes.ca_sequence_number = p_ca_sequence_number AND
thes.sequence_number = p_the_sequence_number;
SELECT sca.course_attempt_status,
sca.commencement_dt,
ca.min_submission_dt,
ca.max_submission_dt,
ca.govt_type_of_activity_cd,
sca.person_id,
sca.course_cd
FROM IGS_RE_CANDIDATURE ca,
IGS_EN_STDNT_PS_ATT sca
WHERE ca.person_id = p_person_id AND
ca.sequence_number = p_ca_sequence_number AND
sca.person_id = ca.person_id AND
sca.course_cd = ca.sca_course_cd;
SELECT 'x'
FROM IGS_RE_THESIS_EXAM tex
WHERE tex.person_id = p_person_id AND
tex.ca_sequence_number = p_ca_sequence_number AND
tex.the_sequence_number = p_the_sequence_number AND
tex.creation_dt < p_creation_dt AND
tex.submission_dt IS NOT NULL AND
tex.thesis_result_cd IS NULL;
SELECT 'x'
FROM IGS_RE_SPRVSR rsup,
IGS_RE_SPRVSR_TYPE rst
WHERE rsup.ca_person_id = p_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.start_dt <= SYSDATE AND
(rsup.end_dt IS NULL OR
rsup.end_dt > SYSDATE) AND
rst.research_supervisor_type = rsup.research_supervisor_type AND
rst.principal_supervisor_ind = 'Y';
SELECT NVL(Sum(cfos.percentage), 0) total, cfos.fos_type_code
FROM igs_re_cdt_fld_of_sy_v cfos
WHERE cfos.fos_type_code <> 'CIP'
AND cfos.person_id = p_person_id
AND cfos.ca_sequence_number = p_ca_sequence_number
GROUP BY cfos.fos_type_code
HAVING Sum(cfos.percentage)<>100;
SELECT SUM(csc.percentage) sum_percentage
FROM IGS_RE_CAND_SEO_CLS csc
WHERE csc.person_id = p_person_id AND
csc.ca_sequence_number = p_ca_sequence_number;
SELECT 'x'
FROM IGS_RE_THESIS_EXAM tex
WHERE tex.person_id = p_person_id AND
tex.ca_sequence_number = p_ca_sequence_number AND
tex.the_sequence_number = p_the_sequence_number AND
tex.creation_dt < p_creation_dt AND
tex.submission_dt > p_submission_dt;
SELECT 'x'
FROM IGS_RE_THS_PNL_MBR tpm,
IGS_RE_THESIS_RESULT thr
WHERE tpm.person_id = p_person_id AND
tpm.ca_sequence_number = p_ca_sequence_number AND
tpm.the_sequence_number = p_the_sequence_number AND
tpm.creation_dt = p_creation_dt AND
tpm.confirmed_dt IS NOT NULL AND
thr.thesis_result_cd = tpm.thesis_result_cd AND
thr.s_thesis_result_cd <> cst_no_result;
SELECT 'x'
FROM igs_en_spa_awd_aim
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd
AND ( end_dt IS NULL OR
(end_dt IS NOT NULL AND complete_ind = 'Y')
);
SELECT 'x'
FROM igs_en_spa_awd_aim
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd
AND NVL(complete_ind,'N') = 'N'
AND end_dt IS NULL;
cst_insert CONSTANT VARCHAR2(10) := 'INSERT';
cst_update CONSTANT VARCHAR2(10) := 'UPDATE';
cst_delete CONSTANT VARCHAR2(10) := 'DELETE';
cst_deleted CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'DELETED';
SELECT ca.sca_course_cd
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
ca.sequence_number = p_ca_sequence_number;
SELECT sca.course_attempt_status
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = cp_sca_course_cd;
SELECT thev.thesis_status
FROM IGS_RE_THESIS_V thev
WHERE thev.person_id = p_person_id AND
thev.ca_sequence_number = p_ca_sequence_number AND
thev.sequence_number = p_the_sequence_number;
cst_insert,
cst_update,
cst_delete)) THEN
-- 1. Not if the candidature is not linked to enrolments
IF (v_sca_course_cd IS NULL) THEN
p_message_name := 'IGS_RE_CANT_IU_THESIS_EXM_DET';
cst_deleted)) THEN
CLOSE c_thev;
IF (p_transaction_type = cst_delete) THEN
-- 1. Cannot delete if the examination has been submitted
IF (p_submission_dt IS NOT NULL) THEN
p_message_name := 'IGS_RE_CANT_DEL_THESIS_EXAM';
SELECT 'x'
FROM IGS_RE_THS_EXAM_TYPE tet
WHERE tet.thesis_exam_type = p_thesis_exam_type AND
tet.closed_ind = 'Y';
SELECT thr.closed_ind
FROM IGS_RE_THESIS_RESULT thr
WHERE thr.thesis_result_cd = p_thesis_result_cd;
SELECT tpm.thesis_result_cd
FROM IGS_RE_THS_PNL_MBR tpm
WHERE tpm.ca_person_id = p_person_id AND
tpm.ca_sequence_number = p_ca_sequence_number AND
tpm.the_sequence_number = p_the_sequence_number AND
tpm.creation_dt = p_creation_dt AND
tpm.confirmed_dt IS NOT NULL AND
tpm.thesis_result_cd IS NOT NULL;
SELECT tpt.recommended_panel_size
FROM IGS_RE_THS_PNL_TYPE tpt
WHERE tpt.thesis_panel_type = p_thesis_panel_type;
SELECT confirmed_dt
FROM IGS_RE_THS_PNL_MBR tpm
WHERE tpm.ca_person_id = p_person_id AND
tpm.ca_sequence_number = p_ca_sequence_number AND
tpm.the_sequence_number = p_the_sequence_number AND
tpm.creation_dt = p_creation_dt;
SELECT 'x'
FROM IGS_RE_THESIS_V thev
WHERE thev.person_id = p_person_id AND
thev.ca_sequence_number = p_ca_sequence_number AND
thev.sequence_number = p_the_sequence_number AND
thev.thesis_status = cst_examined;
SELECT 'x'
FROM IGS_RE_THESIS_EXAM tex
WHERE tex.person_id = p_person_id AND
tex.ca_sequence_number = p_ca_sequence_number AND
tex.the_sequence_number = p_the_sequence_number AND
tex.creation_dt > p_creation_dt AND
tex.submission_dt IS NOT NULL;
SELECT 'x'
FROM IGS_RE_THS_PNL_TYPE tpt
WHERE tpt.thesis_panel_type = p_thesis_panel_type AND
tpt.closed_ind = 'Y';