[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM igs_pe_usr_aval
WHERE validation = 'CHKENCUMB'
AND override_ind = 'Y'
AND person_type = cp_person_type;
SELECT ppe.person_id,
ppe.encumbrance_type,
peff.pee_start_dt hold_start_dt,
peff.expiry_dt
FROM igs_pe_pers_encumb ppe,
igs_pe_persenc_effct peff
WHERE ppe.person_id = peff.person_id
AND ppe.encumbrance_type = peff.encumbrance_type
AND ppe.start_dt=peff.pen_start_dt
AND peff.s_encmb_effect_type = 'DENY_EACT'
AND ppe.person_id = cp_person_id;
SELECT hro.hold_rel_or_ovr
FROM igs_en_elgb_ovr_all eoa,
igs_pe_hold_rel_ovr hro
WHERE eoa.elgb_override_id = hro.elgb_override_id
AND eoa.person_id = cp_person_id
AND eoa.cal_type = p_load_calendar_type
AND eoa.ci_sequence_number = p_load_cal_sequence_number
AND hro.hold_type = cp_hold_type;
SELECT enr_method_type FROM igs_en_method_type
WHERE self_service = 'Y'
AND closed_ind = 'N';
SELECT 'Y'
FROM igs_pe_usr_aval
WHERE validation = 'CHKENCUMB'
AND override_ind = 'Y'
AND person_type = cp_person_type;
SELECT ppe.person_id,
ppe.encumbrance_type,
peff.pee_start_dt hold_start_dt,
peff.expiry_dt
FROM igs_pe_pers_encumb ppe,
IGS_PE_PERSENC_EFFCT peff
WHERE ppe.encumbrance_type = peff.encumbrance_type
AND ppe.start_dt=peff.pen_start_dt
AND s_encmb_effect_type in ('SUS_SRVC','RVK_SRVC')
AND ppe.person_id = cp_person_id;
SELECT hro.hold_rel_or_ovr
FROM igs_en_elgb_ovr_all eoa,
igs_pe_hold_rel_ovr hro
WHERE eoa.elgb_override_id = hro.elgb_override_id
AND eoa.person_id = cp_person_id
AND eoa.cal_type = p_load_calendar_type
AND eoa.ci_sequence_number = p_load_cal_sequence_number
AND hro.hold_type = cp_hold_type;
SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkup.step_group_type,
eru.s_rule_call_cd,
eru.rul_sequence_number
FROM igs_en_cpd_ext eru,
igs_pe_usr_aval_all uact,
igs_lookups_view lkup
WHERE eru.s_enrolment_step_type = lkup.lookup_code
AND lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'
AND lkup.step_group_type = 'PERSON'
AND eru.s_enrolment_step_type = uact.validation (+)
AND uact.person_type (+) = p_person_type
AND nvl(uact.override_ind,'N') = 'N'
AND eru.enrolment_cat = p_enrollment_category
AND (eru.s_student_comm_type = p_comm_type OR eru.s_student_comm_type = 'ALL')
AND eru.enr_method_type = cp_enr_method_type
ORDER BY eru.step_order_num;
SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkup.step_group_type,
eru.s_rule_call_cd,
eru.rul_sequence_number
FROM igs_en_cpd_ext eru,
igs_lookups_view lkup
WHERE eru.s_enrolment_step_type = lkup.lookup_code
AND lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'
AND lkup.step_group_type = 'PERSON'
AND eru.enrolment_cat = p_enrollment_category
AND (eru.s_student_comm_type = p_comm_type OR eru.s_student_comm_type = 'ALL')
AND eru.enr_method_type = cp_enr_method_type
ORDER BY eru.step_order_num;
SELECT adm_admission_appl_number,
adm_sequence_number
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id
AND course_cd = p_program_cd
AND version_number = p_program_version;
SELECT 'TRUE'
FROM igs_tr_item ti,
igs_tr_status ts
WHERE ts.tracking_status = ti.tracking_status
AND ts.s_tracking_status <> 'COMPLETE'
AND ti.tracking_id IN ( SELECT ad.tracking_id
FROM igs_tr_type tt,
igs_tr_item ti,
igs_ad_aplins_admreq ad
WHERE tt.s_tracking_type = 'POST_ADMISSION'
AND ad.tracking_id = ti.tracking_id
AND ti.tracking_type = tt.tracking_type
AND ad.person_id = cp_person_id
AND ad.course_cd = cp_course_cd
AND ad.admission_appl_number = cp_adm_appl_number
AND ad.sequence_number = cp_adm_seq_number );
SELECT sci.intermission_type,
sci.start_dt
FROM igs_en_stdnt_ps_intm sci,
IGS_EN_INTM_TYPES eit,
igs_en_stdnt_ps_att spa
WHERE sci.person_id = p_person_id
AND sci.course_cd = p_program_cd
AND sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
AND sci.approved = eit.appr_reqd_ind
AND eit.intermission_type = sci.intermission_type
AND spa.person_id = sci.person_id
AND spa.course_cd = sci.course_cd
AND ((trunc(sysdate) between sci.start_dt and sci.end_dt)
OR
((trunc(sysdate) > sci.end_dt) AND (spa.course_attempt_status = 'INTERMIT')));
SELECT visa_type,
visa_number
FROM igs_pe_visa
WHERE person_id = p_person_id;
igs_en_add_units_api.delete_ss_warnings(p_person_id,
p_program_cd,
p_load_calendar_type,
p_load_cal_sequence_number,
NULL, -- uoo_id
NULL, -- message_for
l_steps);
SELECT tr.start_dt_time,
tr.end_dt_time
FROM igs_en_timeslot_rslt tr,
igs_en_timeslot_para tp
WHERE tr.person_id = p_person_id
AND tr.igs_en_timeslot_para_id = tp.igs_en_timeslot_para_id
AND tp.cal_type = cp_cal_type
AND tp.sequence_number = cp_sequence_number;
SELECT cal_type,
ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT load_cal_type,
load_ci_sequence_number
FROM igs_ca_teach_to_load_v
WHERE teach_cal_type = cp_teach_cal_type
AND teach_ci_sequence_number = cp_teach_ci_seq_no;
SELECT system_type
FROM igs_pe_person_types
WHERE person_type_code = cp_person_type;
CURSOR get_enr_method IS SELECT enr_method_type FROM igs_en_method_type
WHERE self_service = 'Y'
AND closed_ind = 'N';