[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT distinct pv.course_type career,
sca.course_cd program_cd,
sca.version_number program_version,
ci.cal_type LoadCal,
ci.sequence_number sequence_number,
ci.description description,
ci.start_dt start_dt,
ci.planning_flag planning_flag,
ci.schedule_flag schedule_flag
FROM igs_en_stdnt_ps_att_all sca,
igs_ca_inst_all ci,
igs_ca_type ca,
igs_ca_stat cs,
igs_ca_inst_rel car,
igs_ps_ver_all pv
WHERE sca.person_id = cp_n_person_id
AND sca.course_cd = pv.course_cd
AND sca.version_number = pv.version_number
AND sca.course_attempt_status IN ('ENROLLED','INACTIVE', 'INTERMIT')
AND sca.cal_type = car.sup_cal_type
AND car.sub_cal_type = ci.cal_type
AND car.sub_ci_sequence_number = ci.sequence_number
AND ci.cal_type = ca.cal_type
AND ca.s_cal_cat = 'LOAD'
AND ci.cal_status = cs.cal_status
AND ( ci.schedule_flag ='Y' OR ci.planning_flag ='Y')
AND cs.s_cal_status = 'ACTIVE'
AND ca.closed_ind = 'N'
AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, ci.cal_type,ci.sequence_number)='PRIMARY'
ORDER BY ci.start_dt desc;
SELECT distinct sca.course_cd program_cd,
sca.version_number program_version,
cai.cal_type LoadCal,
cai.sequence_number sequence_number,
cai.description description,
cai.start_dt start_dt,
cai.planning_flag planning_flag,
cai.schedule_flag schedule_flag
FROM IGS_EN_STDNT_PS_ATT_ALL sca,
IGS_CA_INST_REL car,
IGS_CA_INST_ALL cai,
IGS_CA_TYPE ca,
IGS_CA_STAT cs
WHERE sca.person_id = cp_n_person_id
AND sca.course_attempt_status IN ('ENROLLED','INACTIVE', 'INTERMIT')
AND sca.cal_type =car.sup_cal_type
AND cai.cal_type = car.sub_cal_type
AND cai.SEQUENCE_NUMBER = car.sub_ci_sequence_number
AND cai.cal_type = ca.cal_type
AND ca.s_cal_cat = 'LOAD'
AND ( cai.planning_flag ='Y' OR cai.schedule_flag ='Y')
AND ca.closed_ind = 'N'
AND cai.cal_status = cs.cal_status
AND cs.s_cal_status = 'ACTIVE'
ORDER BY cai.start_dt;
SELECT 1
FROM IGS_CA_INST_ALL ci,
IGS_CA_TYPE ca,
IGS_CA_STAT cs
WHERE ci.ss_displayed = 'Y'
AND ci.cal_type = ca.cal_type
AND ca.s_cal_cat = 'LOAD'
AND ci.cal_status = cs.cal_status
AND ca.closed_ind = 'N'
AND cs.s_cal_status = 'ACTIVE' AND ROWNUM <2;
SELECT PLAN_SHT_STATUS
FROM igs_en_spa_terms
WHERE person_id = cp_n_person_id
AND program_cd = cp_c_program
AND term_cal_type = cp_c_cal_type
AND term_sequence_number = cp_n_seq_num;
SELECT 1
FROM IGS_EN_PLAN_UNITS plan
WHERE plan.person_id = cp_n_person_id
AND plan.course_cd = cp_c_program_cd
AND plan.term_cal_type = cp_c_cal_type
AND plan.term_ci_sequence_number = cp_n_seq_num
AND cart_error_flag='N'
AND ROWNUM <2;
SELECT planning_open_dt_alias, schedule_open_dt_alias
FROM igs_en_cal_conf
WHERE s_control_num = 1;
SELECT
sua.person_id,
sca.course_cd,
tt11.load_cal_type term_cal_type,
tt11.load_ci_sequence_number Term_Sequence_Number,
sua.unit_attempt_status
FROM igs_en_su_attempt sua,
igs_en_stdnt_ps_att sca,
igs_ca_teach_to_load_v tt11
WHERE
sca.person_id = sua.person_id
AND sca.course_cd = sua.course_cd
AND sua.unit_attempt_status NOT IN ('UNCONFIRM')
AND tt11.teach_cal_type = sua.cal_type
AND tt11.teach_ci_sequence_number = sua.ci_sequence_number
AND NOT EXISTS (SELECT * FROM igs_ps_usec_ref usr WHERE usr.uoo_id = sua.uoo_id AND NVL(CLASS_SCHEDULE_EXCLUSION_FLAG,'N') = 'Y')
AND sua.person_id = cp_n_person_id
AND sca.course_cd = cp_c_program_cd
AND tt11.load_cal_type = cp_c_cal_type
AND tt11.load_ci_sequence_number = cp_n_seq_num
AND sua.unit_attempt_status IN ('ENROLLED','DISCONTIN','INVALID', 'COMPLETED', 'WAITLISTED');