[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT CORRESPONDENCE_CAT
FROM IGS_EN_STDNT_PS_ATT
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd;
SELECT sl.letter_title
FROM IGS_CO_S_LTR sl
WHERE sl.CORRESPONDENCE_TYPE = p_correspondence_type
AND sl.letter_reference_number = p_letter_reference_number;
SELECT ocr.reference_number
FROM IGS_CO_OU_CO_REF ocr
WHERE ocr.S_OTHER_REFERENCE_TYPE = p_s_other_reference_type
AND ocr.other_reference = p_other_reference;
SELECT person_id,
CORRESPONDENCE_TYPE,
CAL_TYPE,
ci_sequence_number,
course_cd,
cv_version_number,
unit_cd,
uv_version_number,
S_OTHER_REFERENCE_TYPE,
other_reference,
ADDR_TYPE,
tracking_id,
request_num,
s_job_name,
request_job_id,
request_job_run_id,
CORRESPONDENCE_CAT,
reference_number,
issue_dt,
dt_sent,
unknown_return_dt,
adt_description,
create_dt,
originator_person_id,
output_num,
oc_comments,
cori_comments
FROM IGS_CO_OU_CO_V
WHERE (p_person_id IS NULL OR
person_id = p_person_id) AND
(p_correspondence_type IS NULL OR
CORRESPONDENCE_TYPE = p_correspondence_type) AND
(p_cal_type IS NULL OR
CAL_TYPE = p_cal_type) AND
(p_ci_sequence_number IS NULL OR
ci_sequence_number = p_ci_sequence_number) AND
(p_course_cd IS NULL OR
course_cd = p_course_cd) AND
(p_cv_version_number IS NULL OR
cv_version_number = p_cv_version_number) AND
(p_unit_cd IS NULL OR
unit_cd = p_unit_cd) AND
(p_uv_version_number IS NULL OR
uv_version_number = p_uv_version_number) AND
(p_s_other_reference_type IS NULL OR
S_OTHER_REFERENCE_TYPE = p_s_other_reference_type) AND
(p_other_reference IS NULL OR
other_reference = p_other_reference) AND
(p_addr_type IS NULL OR
ADDR_TYPE = p_addr_type) AND
(p_tracking_id IS NULL OR
tracking_id = p_tracking_id) AND
(p_request_num IS NULL OR
request_num = p_request_num) AND
(p_s_job_name IS NULL OR
s_job_name = p_s_job_name) AND
(p_request_job_id IS NULL OR
request_job_id = p_request_job_id) AND
(p_request_job_run_id IS NULL OR
request_job_run_id = p_request_job_run_id)
ORDER BY issue_dt DESC,
reference_number DESC;