[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pen.encumbrance_type,
pen.start_dt
FROM IGS_PE_PERS_ENCUMB pen
WHERE pen.person_id = p_person_id AND
TRUNC(p_effective_dt) BETWEEN TRUNC(pen.start_dt) AND
TRUNC(NVL(pen.expiry_dt, p_effective_dt));
SELECT 'x'
FROM IGS_PE_PERSENC_EFFCT pee,
IGS_EN_ENCMB_EFCTTYP_V seet
WHERE pee.person_id = p_person_id AND
pee.encumbrance_type = cp_pen_encumbrance_type AND
TRUNC(pee.pen_start_dt) = TRUNC(cp_pen_start_dt) AND
pee.s_encmb_effect_type = p_encmb_effect_type AND
TRUNC(p_effective_dt) BETWEEN TRUNC(pee.pee_start_dt) AND
TRUNC(NVL(expiry_dt, p_effective_dt)) AND
seet.s_encmb_effect_type = pee.s_encmb_effect_type AND
((seet.apply_to_course_ind = 'Y' AND
pee.course_cd = NVL(p_course_cd, pee.course_cd)) OR
seet.apply_to_course_ind = 'N');
SELECT sca.version_number
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
course_cd = p_course_cd;
SELECT 'x'
FROM IGS_PS_VER crv
WHERE crv.course_cd = p_course_cd AND
crv.version_number = cp_version_number AND
crv.graduate_students_ind = 'Y';
SELECT 'x'
FROM IGS_CA_INST ci,
IGS_CA_STAT cs
WHERE ci.cal_type = p_grd_cal_type AND
ci.sequence_number = p_grd_ci_sequence_number AND
cs.cal_status = ci.cal_status AND
cs.s_cal_status IN ('ACTIVE', 'PLANNED');
SELECT gst.s_graduand_status
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = p_graduand_status;
SELECT gas.s_graduand_appr_status
FROM IGS_GR_APRV_STAT gas
WHERE gas.graduand_appr_status = p_graduand_appr_status;
SELECT gst.s_graduand_status
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = cp_graduand_status;
SELECT gac.grd_cal_type,
gac.grd_ci_sequence_number,
gac.ceremony_number,
gac.us_group_number
FROM IGS_GR_AWD_CRMN gac
WHERE gac.person_id = p_person_id AND
gac.create_dt = p_create_dt AND
gac.award_course_cd = p_award_course_cd AND
gac.award_crs_version_number
= p_award_crs_version_number AND
gac.award_cd = p_award_cd;
SELECT gst.s_graduand_status
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = p_graduand_status;
SELECT gas.s_graduand_appr_status
FROM IGS_GR_APRV_STAT gas
WHERE gas.graduand_appr_status = p_new_graduand_appr_status;
SELECT gst.s_graduand_status
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = p_graduand_status;
SELECT 'x'
FROM IGS_GR_AWD_CRMN gac
WHERE gac.person_id = p_person_id AND
gac.create_dt = p_create_dt;
SELECT gac.grd_cal_type,
gac.grd_ci_sequence_number,
gac.ceremony_number,
gac.award_course_cd,
gac.award_crs_version_number,
gac.award_cd,
gac.us_group_number
FROM IGS_GR_AWD_CRMN gac
WHERE gac.person_id = p_person_id AND
gac.create_dt = p_create_dt;
SELECT 'x'
FROM IGS_PE_PERSON_BASE_V pe
WHERE pe.person_id = cp_id AND
pe.date_of_death is not NULL;
SELECT gr.grd_cal_type,
gr.grd_ci_sequence_number,
gr.graduand_status
FROM IGS_GR_GRADUAND gr
WHERE gr.person_id = p_person_id AND
gr.create_dt <> p_create_dt AND
gr.award_cd = p_award_cd AND
NVL(gr.award_course_cd, 'NULL') = NVL(p_award_course_cd,'NULL') AND
NVL(gr.award_crs_version_number,0) = NVL(p_award_crs_version_number,0);
SELECT 'x'
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = cp_graduand_status AND
gst.s_graduand_status IN (cst_graduated,
cst_surrender);
-- Validate that the update of a graduand record does not occur
-- after the graduation_ceremony ceremony or closing date.
-- Note, warnings only result from failure of the validations.
DECLARE
CURSOR c_gac IS
SELECT gac.grd_cal_type,
gac.grd_ci_sequence_number,
gac.ceremony_number
FROM IGS_GR_AWD_CRMN gac
WHERE gac.person_id = p_person_id AND
gac.create_dt = p_create_dt AND
gac.award_cd = p_award_cd AND
NVL(gac.award_course_cd, 'NULL') = NVL(p_award_course_cd,'NULL') AND
NVL(gac.award_crs_version_number,0) = NVL(p_award_crs_version_number,0);
SELECT gc.ceremony_dt_alias,
gc.ceremony_dai_sequence_number,
gc.closing_dt_alias,
gc.closing_dai_sequence_number
FROM IGS_GR_CRMN gc
WHERE gc.grd_cal_type = cp_grd_cal_type AND
gc.grd_ci_sequence_number = cp_grd_ci_sequence_number AND
gc.ceremony_number = cp_ceremony_number;
-- Validate that the insert or update of a graduand record
-- does not fall outside the ceremony round processing period.
DECLARE
CURSOR c_crd IS
SELECT crd.start_dt_alias,
crd.start_dai_sequence_number,
crd.end_dt_alias,
crd.end_dai_sequence_number
FROM IGS_GR_CRMN_ROUND crd
WHERE crd.grd_cal_type = p_grd_cal_type AND
crd.grd_ci_sequence_number = p_grd_ci_sequence_number;
SELECT sca.version_number,
sca.course_rqrmnt_complete_ind
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_course_cd;
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.version_number = cp_sca_version_number AND
scaae.exit_course_cd = p_award_course_cd AND
scaae.exit_version_number = p_award_crs_version_number AND
scaae.rqrmnts_complete_ind = 'Y';
SELECT sca.version_number
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
course_cd = p_course_cd;
SELECT 'x'
FROM IGS_PE_ALTERNATV_EXT ae
WHERE ae.course_cd = p_course_cd AND
ae.version_number = cp_version_number AND
ae.exit_course_cd = p_award_course_cd;
SELECT 'x'
FROM IGS_GR_APRV_STAT gas
WHERE gas.graduand_appr_status = p_graduand_appr_status AND
gas.closed_ind = 'Y';
SELECT 'x'
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = p_graduand_status AND
gst.closed_ind = 'Y';
SELECT gst.s_graduand_status
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = p_graduand_status;
SELECT 'x'
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_sur_for_course_cd AND
sca.version_number = p_sur_for_crs_version_num;