The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL (absolute_val,
igs_ca_gen_001.calp_get_alias_val (
dai.dt_alias,
dai.sequence_number,
dai.cal_type,
dai.ci_sequence_number
)
) AS term_census_date
FROM igs_ge_s_gen_cal_con sgcc,
igs_ca_da_inst dai
WHERE sgcc.s_control_num = 1
AND dai.dt_alias = sgcc.census_dt_alias
AND dai.cal_type = cp_cal_type
AND dai.ci_sequence_number = cp_cal_seq_number
ORDER BY 1 ASC; -- Order by the census_date to use the earliest value.
SELECT start_dt
FROM igs_ca_inst
WHERE cal_type = p_teach_cal_type
AND sequence_number = p_teach_cal_seq_number;
SELECT system_type
FROM igs_pe_person_types
WHERE person_type_code = cp_person_type;
SELECT override_ind
FROM igs_pe_usr_aval
WHERE validation = cp_validation
AND override_ind = 'Y'
AND person_type = cp_person_type;
SELECT step_override_limit,
step_override_type
FROM igs_en_elgb_ovr_step eos,
igs_en_elgb_ovr eoa
WHERE eoa.elgb_override_id = eos.elgb_override_id
AND eoa.cal_type = cp_cal_type
AND eoa.ci_sequence_number = cp_cal_seq_number
AND eoa.person_id = p_person_id
AND eos.step_override_type = p_eligibility_step_type;
SELECT eou.step_override_limit,
step_override_type
FROM igs_en_elgb_ovr_step eos,
igs_en_elgb_ovr eoa ,
igs_en_elgb_ovr_uoo eou
WHERE eoa.elgb_override_id = eos.elgb_override_id
AND eoa.cal_type = cp_cal_type
AND eoa.ci_sequence_number = cp_cal_seq_number
AND eoa.person_id = p_person_id
AND eos.step_override_type = p_eligibility_step_type
AND eos.elgb_ovr_step_id = eou.elgb_ovr_step_id
AND eou.uoo_id = cp_uoo_id;
SELECT eou.step_override_limit,
step_override_type
FROM igs_en_elgb_ovr_step eos,
igs_en_elgb_ovr eoa ,
igs_en_elgb_ovr_uoo eou
WHERE eoa.elgb_override_id = eos.elgb_override_id
AND eoa.cal_type = cp_cal_type
AND eoa.ci_sequence_number = cp_cal_seq_number
AND eoa.person_id = p_person_id
AND eos.step_override_type = p_eligibility_step_type
AND eos.elgb_ovr_step_id = eou.elgb_ovr_step_id
AND eou.unit_cd = cp_unit_cd
AND eou.version_number = cp_version_number
AND ( eou.uoo_id = -1 OR eou.uoo_id IS NULL) ;
SELECT step_override_limit,
step_override_type
FROM igs_en_elgb_ovr_step eos,
igs_en_elgb_ovr eoa
WHERE eoa.elgb_override_id = eos.elgb_override_id
AND eoa.cal_type = cp_cal_type
AND eoa.ci_sequence_number = cp_cal_seq_number
AND eoa.person_id = p_person_id
AND eos.step_override_type = p_eligibility_step_type
AND NOT EXISTS ( SELECT 'X'
FROM igs_en_elgb_ovr_uoo eou
WHERE eos.elgb_ovr_step_id = eou.elgb_ovr_step_id );
SELECT unit_cd,
version_number,
cal_type,
ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT NVL (usec.enrollment_maximum, uv.enrollment_maximum) enrollment_maximum,
uoo.enrollment_actual enrollment_actual
FROM igs_ps_usec_lim_wlst usec,
igs_ps_unit_ver uv,
igs_ps_unit_ofr_opt uoo
WHERE uoo.unit_cd = uv.unit_cd
AND uoo.version_number = uv.version_number
AND uoo.uoo_id = usec.uoo_id (+)
AND uoo.uoo_id = p_uoo_id;
SELECT rsv_org_unit_pri_id
FROM igs_ps_rsv_ogpri
WHERE org_unit_cd = (SELECT owner_org_unit_cd
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id);
SELECT rsv_org_unit_pri_id,
rsv_org_unit_prf_id,
percentage_reserved
FROM igs_ps_rsv_orgun_prf
WHERE rsv_org_unit_pri_id = cp_org_unit_priority_id;
SELECT rsv_uop_pri_id
FROM igs_ps_rsv_uop_pri
WHERE (unit_cd,
version_number,
calender_type,
ci_sequence_number) = (SELECT unit_cd,
version_number,
cal_type,
ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id);
SELECT rsv_uop_pri_id,
rsv_uop_prf_id,
percentage_reserved
FROM igs_ps_rsv_uop_prf
WHERE rsv_uop_pri_id = cp_uop_priority_id;
SELECT rsv_usec_pri_id
FROM igs_ps_rsv_usec_pri
WHERE uoo_id = p_uoo_id;
SELECT rsv_usec_pri_id,
rsv_usec_prf_id,
percentage_reserved
FROM igs_ps_rsv_usec_prf
WHERE rsv_usec_pri_id = cp_usec_priority_id;
SELECT actual_seat_enrolled
FROM igs_ps_rsv_ext
WHERE uoo_id = cp_uoo_id
AND priority_id = cp_priority_id
AND preference_id = cp_preference_id
AND rsv_level = cp_level;
SELECT unit_section_status,enrollment_actual, waitlist_actual,reserved_seating_allowed
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_uoo_id;
SELECT override_enrollment_max, enrollment_maximum
FROM igs_ps_unit_ver
WHERE (unit_cd , version_number ) IN (SELECT unit_cd , version_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id);
SELECT override_enrollment_max, enrollment_maximum
FROM igs_ps_usec_lim_wlst
WHERE uoo_id = p_uoo_id;
SELECT version_number
FROM igs_en_stdnt_ps_att
WHERE person_id= p_person_id AND
course_cd = p_course_cd;
SELECT grp.max_enr_group, grp.max_ovr_group, grpmem.usec_x_listed_group_id
FROM igs_ps_usec_x_grpmem grpmem,
igs_ps_usec_x_grp grp
WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
AND grpmem.uoo_id = l_uoo_id;
SELECT grp.max_enr_group, grp.max_ovr_group, ucm.class_meet_group_id
FROM igs_ps_uso_clas_meet ucm,
igs_ps_uso_cm_grp grp
WHERE grp.class_meet_group_id = ucm.class_meet_group_id
AND ucm.uoo_id = l_uoo_id;
SELECT SUM(enrollment_actual)
FROM igs_ps_unit_ofr_opt uoo,
igs_ps_usec_x_grpmem ugrp
WHERE uoo.uoo_id = ugrp.uoo_id
AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;
SELECT SUM(enrollment_actual)
FROM igs_ps_unit_ofr_opt uoo,
igs_ps_uso_clas_meet ucls
WHERE uoo.uoo_id = ucls.uoo_id
AND ucls.class_meet_group_id = l_class_meet_group_id;
SELECT rsv_seat_ext_id FROM igs_en_su_attempt
WHERE person_id = p_person_id
AND course_cd = p_course_cd
AND p_uoo_id = p_uoo_id
AND rsv_seat_ext_id IS NOT NULL;
SELECT waitlist_allowed_flag
FROM igs_en_inst_wl_stps;
SELECT waitlist_alwd
FROM igs_en_inst_wlst_opt
WHERE cal_type = cp_cal_type;
SELECT waitlist_allowed , max_students_per_waitlist
FROM igs_ps_usec_lim_wlst
WHERE uoo_id = cp_uoo_id ;
SELECT uop.waitlist_allowed, uop.max_students_per_waitlist
FROM igs_ps_unit_ofr_pat uop,
igs_ps_unit_ofr_opt uoo
WHERE uop.unit_cd = uoo.unit_cd
AND uop.version_number = uoo.version_number
AND uop.cal_type = uoo.cal_type
AND uop.ci_sequence_number = uoo.ci_sequence_number
AND uoo.uoo_id = cp_uoo_id
AND uop.delete_flag ='N';
SELECT sca.cal_type
FROM igs_en_stdnt_ps_att sca
WHERE sca.person_id = cp_person_id
AND sca.course_cd = cp_course_cd;
SELECT secc.load_effect_dt_alias
FROM igs_en_cal_conf secc
WHERE secc.s_control_num = 1;
SELECT ci.cal_type,
ci.sequence_number
FROM igs_ca_inst ci,
igs_ca_stat cs
WHERE ci.cal_type = cp_cal_type
AND ci.start_dt <= cp_effective_dt
AND ci.end_dt >= cp_effective_dt
AND cs.cal_status = ci.cal_status
AND cs.s_cal_status = cst_active
ORDER BY ci.start_dt DESC;
SELECT ci.cal_type,
ci.sequence_number,
ci.start_dt,
ci.end_dt
FROM igs_ca_type ct,
igs_ca_inst ci,
igs_ca_stat cs,
igs_ca_inst_rel cir
WHERE ct.closed_ind = 'N'
AND cs.s_cal_status = cst_active
AND ci.cal_status = cs.cal_status
AND ct.s_cal_cat = cst_load
AND ci.cal_type = ct.cal_type
AND cir.sub_cal_type = ci.cal_type
AND cir.sub_ci_sequence_number =ci.sequence_number
AND cir.sup_cal_type = cp_cal_type
AND cir.sup_ci_sequence_number = cp_sequence_number
AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,
igs_ca_type ct
WHERE cir.sup_cal_type = cp_cal_type
AND cir.sup_ci_sequence_number = cp_sequence_number
AND cir.sub_cal_type = ci.cal_type
AND cir.sub_ci_sequence_number = ci.sequence_number
AND ct.cal_type = cir.sup_cal_type
AND ct.s_cal_cat = cst_academic)
ORDER BY ci.start_dt DESC;
SELECT daiv.alias_val
FROM igs_ca_da_inst_v daiv
WHERE daiv.cal_type = cp_cal_type
AND daiv.ci_sequence_number = cp_ci_sequence_number
AND daiv.dt_alias = cp_load_effect_dt_alias;
SELECT sequence_number
FROM igs_ps_stage
WHERE course_cd = p_course_cd AND
version_number = p_version_number AND
course_stage_type = p_preference_code
ORDER BY sequence_number;
SELECT text_1
FROM igs_pr_s_scratch_pad_v
WHERE creation_dt = cp_creation_dt AND
(cp_key_1 IS NULL OR
key_1 = cp_key_1) AND
(cp_key_2 IS NULL OR
key_2 = cp_key_2) AND
(cp_key_3 IS NULL OR
key_3 = cp_key_3) AND
(cp_key_4 IS NULL OR
key_4 = cp_key_4) AND
(cp_key_5 IS NULL OR
key_5 = cp_key_5) AND
(cp_key_6 IS NULL OR
key_6 = cp_key_6);
SELECT unit_cd,
version_number,
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 = p_cal_type
AND teach_ci_Sequence_number = p_ci_sequence_number ;
SELECT eou.step_override_limit
FROM igs_en_elgb_ovr_step eos,
igs_en_elgb_ovr eo ,
igs_en_elgb_ovr_uoo eou
WHERE eos.step_override_type = 'VAR_CREDIT_APPROVAL' AND
eos.elgb_override_id = eo.elgb_override_id AND
eo.person_id = p_person_id AND
eo.cal_type = cp_cal_type AND
eo.ci_sequence_number = cp_sequence_number AND
eos.elgb_ovr_step_id = eou.elgb_ovr_step_id AND
eou.uoo_id = p_uoo_id ;
SELECT eou.step_override_limit
FROM igs_en_elgb_ovr_step eos,
igs_en_elgb_ovr eo ,
igs_en_elgb_ovr_uoo eou
WHERE eos.step_override_type = 'VAR_CREDIT_APPROVAL' AND
eos.ELGB_OVERRIDE_ID = eo.ELGB_OVERRIDE_ID AND
eo.person_id = p_person_id AND
eou.unit_cd = cp_unit_cd AND
eou.version_number = cp_version_number AND
( eou.uoo_id IS NULL OR eou.uoo_id = -1 ) AND
eos.elgb_ovr_step_id = eou.elgb_ovr_step_id AND
eo.CAL_TYPE = cp_cal_type AND
eo.CI_SEQUENCE_NUMBER = cp_sequence_number ;
SELECT alternate_code, start_dt, end_dt
FROM IGS_CA_INST
WHERE cal_type = p_load_cal_type
AND sequence_number = p_load_ci_seq_num ;
SELECT NVL(SCAH1.hist_start_dt,SCA1.last_update_date) hist_start_dt
FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1
WHERE SCA1.person_id = SCAH1.person_id(+)
AND SCA1.course_cd = SCAH1.course_cd(+)
AND SCA1.person_id = p_person_id
AND SCA1.course_cd = p_course_cd
AND SUBSTR( NVL(SCAH1.course_attempt_status, NVL(IGS_AU_GEN_003.audp_get_scah_col('COURSE_ATTEMPT_STATUS',SCAH1.person_id,
SCAH1.course_cd,SCAH1.hist_end_dt), SCA1.course_attempt_status)),1,10) = l_cst_enrolled
ORDER BY NVL(SCAH1.hist_start_dt,SCA1.last_update_date);
SELECT sca.cal_type
FROM igs_en_stdnt_ps_att sca
WHERE sca.person_id = cp_person_id
AND sca.course_cd = cp_course_cd;
SELECT sca.cal_type
FROM igs_en_stdnt_ps_att sca
WHERE sca.person_id = cp_person_id
AND sca.course_cd = cp_course_cd;
SELECT special_permission_ind, cal_type, ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT approval_status, Transaction_type
FROM igs_en_spl_perm
WHERE student_person_id = p_person_id
AND uoo_id =p_uoo_id
AND REQUEST_TYPE = 'SPL_PERM'
AND transaction_type <> 'WITHDRAWN';
SELECT system_type
FROM igs_pe_person_types
WHERE person_type_code = p_person_type;
l_step_def_query := 'SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type
FROM igs_en_cpd_ext eru, igs_lookups_view lkv
WHERE eru.s_enrolment_step_type = ''SPL_PERM'' AND
eru.s_enrolment_step_type =lkv.lookup_code AND
lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type =
''UNIT'' AND eru.enrolment_cat = :1 AND eru.enr_method_type = :2
AND (eru.s_student_comm_type = :3 OR eru.s_student_comm_type = ''ALL'')
ORDER BY eru.step_order_num';
l_step_def_query := 'SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type
FROM igs_en_cpd_ext eru, igs_pe_usr_aval_all uact, igs_lookups_view lkv
WHERE eru.s_enrolment_step_type = ''SPL_PERM'' AND
eru.s_enrolment_step_type =lkv.lookup_code AND
lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type = ''UNIT'' AND
eru.s_enrolment_step_type = uact.validation(+) AND
uact.person_type(+) = :1 AND
NVL(uact.override_ind,''N'') = ''N'' AND
eru.enrolment_cat = :2 AND
eru.enr_method_type = :3
AND ( eru.s_student_comm_type = :4 OR eru.s_student_comm_type = ''ALL'' )
ORDER BY eru.step_order_num';
SELECT NVL(auditable_ind, 'N'), NVL(audit_permission_ind, 'N')
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT approval_status, transaction_type
FROM igs_en_spl_perm
WHERE student_person_id = p_person_id
AND uoo_id =p_uoo_id
AND REQUEST_TYPE = 'AUDIT_PERM'
AND transaction_type <> 'WITHDRAWN';
SELECT system_type
FROM igs_pe_person_types
WHERE person_type_code = cp_person_type;
SELECT
eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant
FROM
igs_en_cpd_ext eru,
igs_lookups_view lkv
WHERE
eru.s_enrolment_step_type = cp_step AND
eru.s_enrolment_step_type =lkv.lookup_code AND
lkv.lookup_type = 'ENROLMENT_STEP_TYPE_EXT' AND
lkv.step_group_type ='UNIT' AND
eru.enrolment_cat = cp_enrollment_category AND
eru.enr_method_type = cp_enr_method AND
(eru.s_student_comm_type = cp_commencement_type OR eru.s_student_comm_type = 'ALL')
ORDER BY eru.step_order_num;
SELECT
eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant
FROM
igs_en_cpd_ext eru,
igs_pe_usr_aval_all uact,
igs_lookups_view lkv
WHERE
eru.s_enrolment_step_type = cp_step AND
eru.s_enrolment_step_type =lkv.lookup_code AND
lkv.lookup_type = 'ENROLMENT_STEP_TYPE_EXT' AND
lkv.step_group_type = 'UNIT' AND
eru.s_enrolment_step_type = uact.validation(+) AND
uact.person_type(+) = cp_person_type AND
NVL(uact.override_ind,'N') = 'N' AND
eru.enrolment_cat = cp_enrollment_category AND
eru.enr_method_type = cp_enr_method AND
( eru.s_student_comm_type = cp_commencement_type OR eru.s_student_comm_type = 'ALL' )
ORDER BY eru.step_order_num;
SELECT core_indicator_code
FROM igs_en_su_attempt
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd
AND uoo_id = cp_uoo_id;
SELECT secc.load_effect_dt_alias
FROM igs_en_cal_conf secc
WHERE secc.s_control_num = 1;
SELECT ci.cal_type,
ci.sequence_number,
ci.alternate_code,
ci.start_dt,
ci.end_dt
FROM igs_ca_type ct,
igs_ca_inst ci,
igs_ca_stat cs,
igs_ca_inst_rel cir
WHERE cs.s_cal_status = cst_active
AND ci.cal_status = cs.cal_status
AND ct.s_cal_cat = cst_load
AND ci.cal_type = ct.cal_type
AND CIR.SUB_CAL_TYPE = CI.CAL_TYPE
AND cir.sub_ci_sequence_number =ci.sequence_number
AND cir.sup_cal_type = cp_cal_type
ORDER BY ci.start_dt DESC;
SELECT daiv.alias_val
FROM igs_ca_da_inst_v daiv
WHERE daiv.cal_type = cp_cal_type
AND daiv.ci_sequence_number = cp_ci_sequence_number
AND daiv.dt_alias = cp_load_effect_dt_alias;
SELECT secc.load_effect_dt_alias
FROM igs_en_cal_conf secc
WHERE secc.s_control_num = 1;
SELECT cal_type, sequence_number
FROM IGS_CA_INST
WHERE CAL_TYPE = cp_acad_cal_type
ORDER BY start_dt DESC;
SELECT ci.cal_type,
ci.sequence_number,
ci.alternate_code,
ci.start_dt,
ci.end_dt
FROM igs_ca_type ct,
igs_ca_inst ci,
igs_ca_stat cs,
igs_ca_inst_rel cir
WHERE cs.s_cal_status = cst_active
AND ci.cal_status = cs.cal_status
AND ct.s_cal_cat = cst_load
AND ci.cal_type = ct.cal_type
AND CIR.SUB_CAL_TYPE = CI.CAL_TYPE
AND cir.sub_ci_sequence_number =ci.sequence_number
AND cir.sup_cal_type = cp_acad_cal_type
AND cir.sup_ci_sequence_number = cp_acad_ci_sequence_number
ORDER BY ci.start_dt DESC;
SELECT daiv.alias_val
FROM igs_ca_da_inst_v daiv
WHERE daiv.cal_type = cp_cal_type
AND daiv.ci_sequence_number = cp_ci_sequence_number
AND daiv.dt_alias = cp_load_effect_dt_alias;
SELECT ci.cal_type,
ci.sequence_number,
ci.alternate_code,
ci.start_dt,
ci.end_dt
FROM igs_ca_type ct,
igs_ca_inst ci,
igs_ca_stat cs,
igs_ca_inst_rel cir
WHERE cs.s_cal_status = cst_active
AND ci.cal_status = cs.cal_status
AND ct.s_cal_cat = cst_load
AND ci.cal_type = ct.cal_type
AND CIR.SUB_CAL_TYPE = CI.CAL_TYPE
AND cir.sub_ci_sequence_number =ci.sequence_number
AND cir.sup_cal_type = cp_cal_type
AND ci.start_dt <= SYSDATE
AND ci.end_dt >= SYSDATE
ORDER BY ci.start_dt;
SELECT sca.cal_type
FROM igs_en_stdnt_ps_att sca
WHERE sca.person_id = cp_person_id
AND sca.course_cd = cp_course_cd;
SELECT secc.load_effect_dt_alias
FROM igs_en_cal_conf secc
WHERE secc.s_control_num = 1;
SELECT ci.cal_type,
ci.sequence_number
FROM igs_ca_inst ci,
igs_ca_stat cs
WHERE ci.cal_type = cp_cal_type
AND ci.start_dt <= cp_effective_dt
AND ci.end_dt >= cp_effective_dt
AND cs.cal_status = ci.cal_status
AND cs.s_cal_status = cst_active
ORDER BY ci.start_dt DESC;
SELECT ci.cal_type,
ci.sequence_number,
ci.start_dt,
ci.end_dt
FROM igs_ca_type ct,
igs_ca_inst ci,
igs_ca_stat cs,
igs_ca_inst_rel cir
WHERE ct.closed_ind = 'N'
AND cs.s_cal_status = cst_active
AND ci.cal_status = cs.cal_status
AND ct.s_cal_cat = cst_load
AND ci.cal_type = ct.cal_type
AND cir.sub_cal_type = ci.cal_type
AND cir.sub_ci_sequence_number =ci.sequence_number
AND cir.sup_cal_type = cp_cal_type
AND cir.sup_ci_sequence_number = cp_sequence_number
AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,
igs_ca_type ct
WHERE cir.sup_cal_type = cp_cal_type
AND cir.sup_ci_sequence_number = cp_sequence_number
AND cir.sub_cal_type = ci.cal_type
AND cir.sub_ci_sequence_number = ci.sequence_number
AND ct.cal_type = cir.sup_cal_type
AND ct.s_cal_cat = cst_academic)
ORDER BY ci.start_dt DESC;
SELECT daiv.alias_val
FROM igs_ca_da_inst_v daiv
WHERE daiv.cal_type = cp_cal_type
AND daiv.ci_sequence_number = cp_ci_sequence_number
AND daiv.dt_alias = cp_load_effect_dt_alias;
SELECT sca.cal_type
FROM igs_en_stdnt_ps_att sca
WHERE sca.person_id = cp_person_id
AND sca.course_cd = cp_course_cd;