[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT responsible_org_unit_cd org_unit_code
FROM igs_ps_ver pver
WHERE pver.course_cd = p_course_cd
AND pver.version_number = p_ver_num;
SELECT
admission_test_type adm_test_type,
test_date adm_test_date
FROM
igs_ad_test_results
WHERE person_id = p_person_id
AND admission_test_type = 'ATB';
SELECT course_cd, adm_admission_appl_number, version_number, commencement_dt, course_attempt_status, attendance_mode, location_cd
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id
AND key_program = 'Y' ;
SELECT COUNT(person_id)
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id;
SELECT COUNT(*) cnt FROM igs_ad_ps_appl_inst
WHERE person_id=p_person_id AND
course_cd = cp_course_cd;
SELECT adm.course_type adm_course_type,adps.course_cd adm_course_cd,
adps.admission_appl_number adm_appl_number
FROM igs_ad_ps_appl_inst adps,igs_en_stdnt_ps_att enps,
igs_ps_ver adm,igs_ps_ver enrl
WHERE adps.person_id=p_person_id AND adps.person_id= enps.person_id
AND enps.course_cd=cp_course_cd AND enps.course_cd=enrl.course_cd
AND adps.course_cd = adm.course_cd AND adm.course_type=enrl.course_type;
SELECT
ci.cal_type enrl_load_cal_type,
ci.sequence_number enrl_load_seq_num ,
ci.alternate_code enrolled_term
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 = p_acad_cal_type
AND sub_ci_sequence_number = p_acad_seq_num
UNION
SELECT sub_cal_type,
sub_ci_sequence_number
FROM igs_ca_inst_rel
WHERE sup_cal_type = p_acad_cal_type
AND sup_ci_sequence_number = p_acad_seq_num
)
AND
SYSDATE BETWEEN ci.start_dt AND ci.end_dt
ORDER BY ci.start_dt;
SELECT
course_type enrl_program_type
FROM igs_ps_ver
WHERE
course_cd = p_course_cd
AND
version_number = p_version_number;
SELECT adm.adm_cal_type, adm.adm_ci_sequence_number,adm.adm_appl_status, adm.appl_dt,adm.admission_cat, adm.
adm_fee_status,adm.spcl_grp_1, adm.spcl_grp_2, adm_st.s_adm_appl_status appl_status,
adm_ct.s_admission_process_type process_type, adm_ft.s_adm_fee_status fee_status
FROM IGS_AD_APPL adm,
IGS_AD_APPL_STAT adm_st,
IGS_AD_PRCS_CAT adm_ct,
IGS_AD_FEE_STAT adm_ft
WHERE adm.rowid = lv_ad_appl_row_id
AND adm.adm_appl_status = adm_st.adm_appl_status
AND adm.admission_cat = adm_ct.admission_cat
AND adm.adm_fee_status = adm_ft.adm_fee_status;
SELECT prg.attendance_type, prg.attendance_mode, prg.course_cd , prg.crv_version_number, prg.adm_outcome_status, prg.decision_date, prg.adm_offer_resp_status,
prg.actual_response_dt,prg.entry_level,prg.academic_index, prg.unit_set_cd, prg.us_version_number, prg_ou.s_adm_outcome_status ou_status,
prg_of.s_adm_offer_resp_status offer_status, prg.location_cd
FROM igs_ad_ps_appl_inst prg,
igs_ad_ou_stat prg_ou,
igs_ad_ofr_resp_stat prg_of
WHERE prg.rowid = lv_ad_prg_row_id
AND prg.adm_outcome_status = prg_ou.adm_outcome_status
AND prg.adm_offer_resp_status = prg_of.adm_offer_resp_status;
SELECT COUNT(person_id)
FROM igs_pe_athletic_prg_v
WHERE person_id=p_person_id;
SELECT susa.unit_set_cd,susa.course_cd,susa.us_version_number
FROM igs_as_su_setatmpt susa,
igs_en_unit_set us ,
igs_en_unit_set_cat usc,
igs_en_stdnt_ps_att_all ps
WHERE susa.person_id = cp_person_id
AND ps.person_id = susa.person_id
AND susa.course_cd = ps.course_cd
AND ps.key_program = 'Y'
AND susa.course_cd = cp_course_cd
AND susa.PRIMARY_SET_IND = 'Y'
AND susa.selection_dt IS NOT NULL
AND susa.end_dt IS NULL
AND susa.rqrmnts_complete_dt IS NULL
AND susa.unit_set_cd = us.unit_set_cd
AND us.unit_set_cat = usc.unit_set_cat;
SELECT sub_cal_type,
sub_ci_sequence_number
FROM igs_ca_inst_rel,
igf_ap_fa_base_rec_all base
WHERE sup_cal_type = base.ci_cal_type
AND sup_ci_sequence_number = base.ci_sequence_number
AND base.base_id = p_base_id;
SELECT attendance_type FROM igs_en_atd_type_load
WHERE cal_type = l_cal_type
AND lower_enr_load_range = (SELECT MAX(lower_enr_load_range)
FROM igs_en_atd_type_load
WHERE cal_type = l_cal_type);
SELECT base_id
FROM igf_ap_fa_base_rec_all
WHERE person_id = cp_person_id
AND ci_cal_type = cp_ci_cal_type
AND ci_sequence_number = cp_ci_sequence_number;
SELECT
adm_appl_rec.adm_appl_status,
adm_appl_rec.appl_status,
adm_appl_rec.appl_dt,
lv_class_standing, -- class_standing
lv_credit_pts,
adm_appl_rec.admission_cat,
adm_appl_rec.process_type,
appl_prog_rec.course_cd || ' ' || appl_prog_rec.crv_version_number,
appl_prog_rec.course_cd,
appl_prog_rec.crv_version_number,
appl_prog_rec.attendance_mode,
appl_prog_rec.attendance_type,
appl_prog_rec.adm_outcome_status,
appl_prog_rec.ou_status,
appl_prog_rec.decision_date,
appl_prog_rec.adm_offer_resp_status,
appl_prog_rec.offer_status,
appl_prog_rec.actual_response_dt,
adm_appl_rec.adm_fee_status,
adm_appl_rec.fee_status,
adm_appl_rec.spcl_grp_1, -- sp_program_1
adm_appl_rec.spcl_grp_2, -- sp_program_2
appl_prog_rec.entry_level, -- entry_level
lv_completion_dt,
appl_prog_rec.academic_index,
lv_adm_org_unit_cd,
appl_prog_rec.unit_set_cd || ' ' || appl_prog_rec.us_version_number,
appl_prog_rec.unit_set_cd,
appl_prog_rec.us_version_number,
enrl_std_rec.commencement_dt,
NULL, -- transfered
lv_multiple,
lv_atb,
enrl_dtl_rec.enrolled_term,
enrl_dtl_rec.enrl_load_cal_type,
enrl_dtl_rec.enrl_load_seq_num,
NULL, -- sap_evaluation_date
NULL, -- sap_selected_flag
lv_mult_prog_d,
enrl_std_rec.course_cd || ' ' || enrl_std_rec.version_number,
enrl_std_rec.course_cd,
enrl_std_rec.version_number,
en_std_rec.enrl_program_type,
l_uset_rec.unit_set_cd, -- enrl_unit_set
l_uset_rec.course_cd, -- enrl_uset_course_cd
l_uset_rec.us_version_number, -- enrl_uset_ver_num
enrl_std_rec.course_attempt_status,
lv_inst_attd,
lv_gpa_curr, -- current_gpa
lv_gpa_cum, -- cumulative_gpa
lv_earned_cp, -- acheived_cr_pts
lv_pred_class_standing, -- pred_class_standing
lv_enrl_org_unit_cd,
enrl_std_rec.attendance_mode,
enrl_std_rec.location_cd,
lv_passed_cp,
lv_adv_stnd_cp + lv_passed_cp, -- enrl_cuml_cp= enrl_cuml_trans_cp+ enrl_total_cp
lv_adv_stnd_cp,
lv_adm_appl_number
FROM DUAL;