[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT commencement_dt
FROM igs_en_stdnt_ps_att_all
WHERE course_cd = cp_course_cd
AND version_number = cp_version_number
AND person_id = cp_person_id;
SELECT course_cd, version_number, cal_type, location_cd, attendance_mode, attendance_type
FROM igs_en_stdnt_ps_att_all
WHERE course_cd = cp_course_cd
AND version_number = cp_version_number
AND person_id = cp_person_id;
SELECT adm.acad_cal_type, adm.adm_cal_type adm_cal_type, adm.adm_ci_sequence_number adm_ci_sequence_number,
acai.expected_completion_yr,acai.expected_completion_perd
FROM igs_ad_appl adm, igs_ad_ps_appl_inst acai
WHERE adm.person_id = acai.person_id
AND adm.admission_appl_number = acai.admission_appl_number
AND adm.person_id = cp_PERSON_ID
AND acai.course_cd = cp_COURSE_CD
AND acai.crv_version_number = cp_CRV_VERSION_NUMBER
AND acai.location_cd = cp_LOCATION_CD
AND acai.attendance_mode = cp_ATTENDANCE_MODE
AND acai.attendance_type = cp_ATTENDANCE_TYPE;
SELECT commencement_dt
FROM igs_en_stdnt_ps_att
WHERE person_id = cp_person_id
AND COURSE_CD = cp_course_cd
AND VERSION_NUMBER = cp_version_number;
SELECT course_type enrl_program_type
FROM igs_ps_ver
WHERE course_cd = cp_course_cd
AND version_number = cp_version_number;
SELECT fa.ci_cal_type, fa.ci_sequence_number, fa.person_id, ci.start_dt, ci.end_dt
FROM igf_ap_fa_base_rec_all fa, igs_ca_inst ci
WHERE fa.BASE_ID = cp_base_id and
fa.ci_cal_type = ci.cal_type and
fa.ci_sequence_number = ci.sequence_number;
SELECT ci.cal_type enrl_load_cal_type,
ci.sequence_number enrl_load_seq_num ,
ci.alternate_code terms,
TRUNC(NVL(get_enr_eff_dt_alias_val(ci.cal_type,ci.sequence_number),ci.start_dt)) enrolled_start_dt,
TRUNC(ci.end_dt) enrolled_end_dt
FROM
igs_ca_inst ci,
igs_ca_type cty
WHERE cty.s_cal_cat = 'LOAD'
AND cty.cal_type = ci.cal_type
AND (ci.cal_type, ci.sequence_number)IN
(SELECT sup_cal_type,
sup_ci_sequence_number
FROM igs_ca_inst_rel
WHERE sub_cal_type = cp_aw_cal_type
AND sub_ci_sequence_number = cp_aw_seq_no
UNION
SELECT sub_cal_type,
sub_ci_sequence_number
FROM igs_ca_inst_rel
WHERE sup_cal_type = cp_aw_cal_type
AND sup_ci_sequence_number = cp_aw_seq_no
)
ORDER BY enrolled_end_dt DESC;
SELECT ci.cal_type enrl_load_cal_type,
ci.sequence_number enrl_load_seq_num ,
ci.alternate_code terms,
TRUNC(NVL(get_enr_eff_dt_alias_val(ci.cal_type,ci.sequence_number),ci.start_dt)) enrolled_start_dt,
TRUNC(ci.end_dt) enrolled_end_dt
FROM
igs_ca_inst ci,
igs_ca_type cty
WHERE cty.s_cal_cat = 'LOAD'
AND cty.cal_type = ci.cal_type
AND (ci.cal_type, ci.sequence_number)IN
(SELECT sup_cal_type,
sup_ci_sequence_number
FROM igs_ca_inst_rel
WHERE sub_cal_type = cp_aw_cal_type
AND sub_ci_sequence_number = cp_aw_seq_no
UNION
SELECT sub_cal_type,
sub_ci_sequence_number
FROM igs_ca_inst_rel
WHERE sup_cal_type = cp_aw_cal_type
AND sup_ci_sequence_number = cp_aw_seq_no
)
ORDER BY enrolled_start_dt;
SELECT spa.*
FROM IGS_EN_SPA_TERMS spa,
(SELECT su.person_id,
su.course_cd,
su.version_number,
tl.load_cal_type,
tl.load_ci_sequence_number
FROM igs_en_su_attempt su,
igs_ca_teach_to_load_v tl
WHERE su.cal_type = tl.teach_cal_type
AND su.ci_sequence_number = tl.teach_ci_sequence_number) unit_attempt
WHERE spa.person_id = cp_person_id
AND spa.term_cal_type = cp_cal_type
AND spa.term_sequence_number = cp_seq_no
AND spa.key_program_flag = 'Y'
AND unit_attempt.person_id = spa.person_id
AND unit_attempt.course_cd = spa.program_cd
AND unit_attempt.version_number = spa.program_version
AND unit_attempt.load_cal_type = spa.term_cal_type
AND unit_attempt.load_ci_sequence_number = spa.term_sequence_number;
SELECT *
FROM igs_en_stdnt_ps_att
WHERE person_id = cp_person_id
AND key_program = 'Y';
SELECT TRUNC(MIN(daiv.alias_val)) enrolled_start_dt
FROM igs_ca_da_inst_v daiv,
igs_en_cal_conf secc
WHERE
secc.s_control_num = 1 AND
daiv.cal_type = cp_cal_type AND
daiv.ci_sequence_number = cp_sequence_number AND
daiv.dt_alias = secc.load_effect_dt_alias;
SELECT fa.person_id
FROM igf_ap_fa_base_rec_all fa
WHERE fa.base_id = cp_base_id ;
SELECT *
FROM igs_en_spa_terms
WHERE person_id = cp_person_id
AND term_cal_type = cp_cal_type
AND term_sequence_number = cp_seq_no
AND key_program_flag = 'Y';
SELECT *
FROM igs_ps_ver_all
WHERE course_cd = cp_program_cd
AND version_number = NVL(cp_version_num,version_number);
SELECT *
FROM igf_ap_fa_ant_data
WHERE base_id = cp_base_id
AND ld_cal_type = cp_ld_cal_type
AND ld_sequence_number = cp_ld_sequence_number;
SELECT dainst.*
FROM igs_ca_da_inst dainst
WHERE dainst.dt_alias = cp_dt_alias
AND dainst.cal_type = cp_cal_type
AND dainst.ci_sequence_number = cp_ci_sequence_number;