[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT discontinuation_reason_cd,
description
FROM IGS_EN_DCNT_REASONCD
WHERE dflt_ind = 'Y' AND
closed_ind = 'N';
SELECT funding_source
FROM IGS_FI_FND_SRC_RSTN
WHERE course_cd = cp_course_cd AND
version_number = cp_version_number AND
dflt_ind = 'Y';
SELECT step_group_type
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_CODE = cp_s_enrolment_step_type AND
LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE';
SELECT 1
FROM IGS_PE_PERS_ENCUMB
WHERE person_id = cp_person_id AND
(l_sysdate BETWEEN start_dt AND (expiry_dt - 1) OR
(expiry_dt IS NULL AND start_dt <= l_sysdate)) ;
SELECT person_id,
course_cd,
version_number,
course_attempt_status,
student_confirmed_ind
FROM IGS_EN_STDNT_PS_ATT
WHERE ((cp_course_cd IS NULL AND person_id = cp_person_id) OR
(cp_course_cd IS NOT NULL AND course_cd = cp_course_cd AND
person_id = cp_person_id));
SELECT IGS_AS_SC_ATMPT_ENR.enrolment_cat,
IGS_AS_SC_ATMPT_ENR.cal_type,
IGS_AS_SC_ATMPT_ENR.ci_sequence_number,
IGS_CA_INST.start_dt,
IGS_CA_INST.end_dt
FROM IGS_AS_SC_ATMPT_ENR,
IGS_CA_INST
WHERE IGS_AS_SC_ATMPT_ENR.person_id = cp_person_id AND
IGS_AS_SC_ATMPT_ENR.course_cd = cp_course_cd AND
IGS_AS_SC_ATMPT_ENR.cal_type = IGS_CA_INST.cal_type AND
IGS_AS_SC_ATMPT_ENR.ci_sequence_number = IGS_CA_INST.sequence_number
ORDER BY IGS_CA_INST.start_dt desc;
SELECT sub_cal_type
FROM IGS_CA_INST_REL
WHERE sup_cal_type = cp_sup_cal_type AND
sup_ci_sequence_number = cp_sup_ci_sequence_number AND
sub_cal_type = cp_sub_cal_type AND
sub_ci_sequence_number = cp_sub_ci_sequence_number;
SELECT ENROLMENT_CAT
FROM IGS_PS_TYPE pt,
IGS_PS_VER pv
WHERE pv.course_cd = p_course_cd AND
pv.course_type = pt.course_type AND
pv.version_number = cp_version_number ;
SELECT course_attempt_status
FROM IGS_EN_STDNT_PS_ATT
WHERE PERSON_ID = cp_person_id
AND COURSE_CD = cp_course_cd;
SELECT cir.sub_cal_type,
cir.sub_ci_sequence_number
FROM IGS_CA_INST_REL cir,
IGS_CA_INST ci,
IGS_CA_TYPE cat,
IGS_CA_STAT cs
WHERE cir.sup_cal_type = p_adm_cal_type AND
cir.sup_ci_sequence_number = p_adm_sequence_number AND
ci.cal_type = cir.sub_cal_type AND
ci.sequence_number = cir.sub_ci_sequence_number AND
cat.cal_type = ci.cal_type AND
cat.S_CAL_CAT = cst_enrolment AND
cs.cal_status = ci.cal_status AND
cs.s_cal_status = cst_active
ORDER BY ci.start_dt;
SELECT person_id
FROM IGS_PE_PERSON
WHERE oracle_username = cp_username;
SELECT *
FROM IGS_PE_PERS_PREFS
WHERE person_id = cp_person_id;
SELECT pue.pue_start_dt,
pue.expiry_dt
FROM IGS_PE_PERSENC_EFFCT pee,
IGS_PE_PERS_UNT_EXCL pue
WHERE pee.person_id = p_person_id AND
pee.s_encmb_effect_type = 'EXC_CRS_U' AND
pee.course_cd = p_course_cd AND
pue.person_id = pee.person_id AND
pue.encumbrance_type = pee.encumbrance_type AND
pue.pen_start_dt = pee.pen_start_dt AND
pue.s_encmb_effect_type = pee.s_encmb_effect_type AND
pue.pee_start_dt = pee.pee_start_dt AND
pue.pee_sequence_number = pee.sequence_number;
SELECT DISTINCT pti.person_type_code
FROM igs_pe_typ_instances_all pti,
igs_pe_person_types ppt
WHERE person_id = p_person_id AND
ppt.system_type = 'STUDENT' AND
ppt.person_type_code = pti.person_type_code AND
SYSDATE BETWEEN start_date and NVL(end_date,igs_ge_date.igsdate('9999/01/01'));
SELECT pti.person_type_code
FROM igs_pe_typ_instances pti
WHERE pti.person_id = p_person_id
AND pti.system_type = 'STAFF'
AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);
SELECT COURSE_ATTEMPT_STATUS
FROM IGS_EN_STDNT_PS_ATT
WHERE PERSON_ID=perid;
v_party_last_update_date DATE;
Select version_number
FROM IGS_EN_STDNT_PS_ATT
WHERE course_cd = cp_course_cd AND
person_id = cp_person_id;
Select award_course_ind
FROM IGS_PS_TYPE pt,
IGS_PS_VER pv
WHERE pv.course_type = pt.course_type AND
pv.course_cd = cp_course_cd AND
pv.version_number = cp_version_number ;
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_num
ORDER BY load_start_dt desc ;
SELECT count(ai.person_id) cnt
FROM IGS_AD_PS_APPL_INST ai,
IGS_AD_OFR_RESP_STAT ar
WHERE ai.adm_offer_resp_status = ar.adm_offer_resp_status AND
ar.s_adm_offer_resp_status = 'ACCEPTED' AND
ai.person_id = cp_person_id AND
ai.course_cd = cp_course_cd ;
SELECT rowid,
person_id,
effective_start_date,
effective_end_date,
religion_cd,
socio_eco_cd,
next_to_kin,
in_state_tuition,
tuition_st_date,
tuition_end_date,
further_education_cd,
MATR_CAL_TYPE,
MATR_SEQUENCE_NUMBER ,
INIT_CAL_TYPE ,
INIT_SEQUENCE_NUMBER ,
RECENT_CAL_TYPE ,
RECENT_SEQUENCE_NUMBER ,
CATALOG_CAL_TYPE ,
CATALOG_SEQUENCE_NUMBER ,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20
FROM IGS_PE_STAT_DETAILS
WHERE person_id = cp_person_id;
Igs_Pe_Stat_Details_Pkg.Insert_Row (
x_rowid => lv_rowid,
x_person_id => p_person_id,
x_effective_start_date => SYSDATE,
x_effective_end_date => NULL,
x_religion_cd => NULL,
x_socio_eco_cd => NULL,
x_next_to_kin => NULL,
x_in_state_tuition => 'N',
x_tuition_st_date => NULL,
x_tuition_end_date => NULL,
x_further_education_cd => NULL,
X_MATR_CAL_TYPE => NULL,
X_MATR_SEQUENCE_NUMBER => NULL,
X_INIT_CAL_TYPE => NULL,
X_INIT_SEQUENCE_NUMBER => NULL,
X_RECENT_CAL_TYPE => NULL,
X_RECENT_SEQUENCE_NUMBER => NULL,
X_CATALOG_CAL_TYPE => NULL,
X_CATALOG_SEQUENCE_NUMBER => NULL,
X_MODE => 'R',
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
x_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_ATTRIBUTE16 => NULL,
X_ATTRIBUTE17 => NULL,
X_ATTRIBUTE18 => NULL,
X_ATTRIBUTE19 => NULL,
X_ATTRIBUTE20 => NULL );
Igs_Pe_Stat_Details_Pkg.update_row (
x_rowid => lv_psd_rec.rowid,
x_person_id => lv_psd_rec.person_id ,
x_effective_start_date => lv_psd_rec.effective_start_date,
x_effective_end_date => lv_psd_rec.effective_end_date,
x_religion_cd => lv_psd_rec.religion_cd,
x_socio_eco_cd => lv_psd_rec.socio_eco_cd,
x_next_to_kin => lv_psd_rec.next_to_kin,
x_in_state_tuition => lv_psd_rec.in_state_tuition,
x_tuition_st_date => lv_psd_rec.tuition_st_date,
x_tuition_end_date => lv_psd_rec.tuition_end_date,
x_further_education_cd => lv_psd_rec.further_education_cd,
X_MATR_CAL_TYPE => lv_cttl_rec.load_cal_type,
X_MATR_SEQUENCE_NUMBER => lv_cttl_rec.load_ci_sequence_number,
X_INIT_CAL_TYPE => lv_psd_rec.INIT_CAL_TYPE,
X_INIT_SEQUENCE_NUMBER => lv_psd_rec.INIT_SEQUENCE_NUMBER,
X_RECENT_CAL_TYPE => lv_psd_rec.RECENT_CAL_TYPE,
X_RECENT_SEQUENCE_NUMBER => lv_psd_rec.RECENT_SEQUENCE_NUMBER ,
X_CATALOG_CAL_TYPE => lv_cttl_rec.load_cal_type ,
X_CATALOG_SEQUENCE_NUMBER => lv_cttl_rec.load_ci_sequence_number,
X_MODE => 'R' ,
X_ATTRIBUTE_CATEGORY => lv_psd_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => lv_psd_rec.ATTRIBUTE1,
X_ATTRIBUTE2 => lv_psd_rec.ATTRIBUTE2,
X_ATTRIBUTE3 => lv_psd_rec.ATTRIBUTE3,
X_ATTRIBUTE4 => lv_psd_rec.ATTRIBUTE4,
X_ATTRIBUTE5 => lv_psd_rec.ATTRIBUTE5,
X_ATTRIBUTE6 => lv_psd_rec.ATTRIBUTE6,
X_ATTRIBUTE7 => lv_psd_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => lv_psd_rec.ATTRIBUTE8,
X_ATTRIBUTE9 => lv_psd_rec.ATTRIBUTE9,
X_ATTRIBUTE10 => lv_psd_rec.ATTRIBUTE10,
X_ATTRIBUTE11 => lv_psd_rec.ATTRIBUTE11,
X_ATTRIBUTE12 => lv_psd_rec.ATTRIBUTE12,
X_ATTRIBUTE13 => lv_psd_rec.ATTRIBUTE13,
X_ATTRIBUTE14 => lv_psd_rec.ATTRIBUTE14,
X_ATTRIBUTE15 => lv_psd_rec.ATTRIBUTE15,
X_ATTRIBUTE16 => lv_psd_rec.ATTRIBUTE16,
X_ATTRIBUTE17 => lv_psd_rec.ATTRIBUTE17,
X_ATTRIBUTE18 => lv_psd_rec.ATTRIBUTE18,
X_ATTRIBUTE19 => lv_psd_rec.ATTRIBUTE19,
X_ATTRIBUTE20 => lv_psd_rec.ATTRIBUTE20);
Igs_Pe_Stat_Details_Pkg.update_row (
x_rowid => lv_psd_rec.rowid,
x_person_id => lv_psd_rec.person_id ,
x_effective_start_date => lv_psd_rec.effective_start_date,
x_effective_end_date => lv_psd_rec.effective_end_date,
x_religion_cd => lv_psd_rec.religion_cd,
x_socio_eco_cd => lv_psd_rec.socio_eco_cd,
x_next_to_kin => lv_psd_rec.next_to_kin,
x_in_state_tuition => lv_psd_rec.in_state_tuition,
x_tuition_st_date => lv_psd_rec.tuition_st_date,
x_tuition_end_date => lv_psd_rec.tuition_end_date,
x_further_education_cd => lv_psd_rec.further_education_cd,
X_MATR_CAL_TYPE => lv_cttl_rec.load_cal_type,
X_MATR_SEQUENCE_NUMBER => lv_cttl_rec.load_ci_sequence_number,
X_INIT_CAL_TYPE => lv_psd_rec.INIT_CAL_TYPE,
X_INIT_SEQUENCE_NUMBER => lv_psd_rec.INIT_SEQUENCE_NUMBER,
X_RECENT_CAL_TYPE => lv_psd_rec.RECENT_CAL_TYPE,
X_RECENT_SEQUENCE_NUMBER => lv_psd_rec.RECENT_SEQUENCE_NUMBER ,
X_CATALOG_CAL_TYPE => lv_psd_rec.CATALOG_CAL_TYPE ,
X_CATALOG_SEQUENCE_NUMBER => lv_psd_rec.CATALOG_SEQUENCE_NUMBER,
X_MODE => 'R' ,
X_ATTRIBUTE_CATEGORY => lv_psd_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => lv_psd_rec.ATTRIBUTE1,
X_ATTRIBUTE2 => lv_psd_rec.ATTRIBUTE2,
X_ATTRIBUTE3 => lv_psd_rec.ATTRIBUTE3,
X_ATTRIBUTE4 => lv_psd_rec.ATTRIBUTE4,
X_ATTRIBUTE5 => lv_psd_rec.ATTRIBUTE5,
X_ATTRIBUTE6 => lv_psd_rec.ATTRIBUTE6,
X_ATTRIBUTE7 => lv_psd_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => lv_psd_rec.ATTRIBUTE8,
X_ATTRIBUTE9 => lv_psd_rec.ATTRIBUTE9,
X_ATTRIBUTE10 => lv_psd_rec.ATTRIBUTE10,
X_ATTRIBUTE11 => lv_psd_rec.ATTRIBUTE11,
X_ATTRIBUTE12 => lv_psd_rec.ATTRIBUTE12,
X_ATTRIBUTE13 => lv_psd_rec.ATTRIBUTE13,
X_ATTRIBUTE14 => lv_psd_rec.ATTRIBUTE14,
X_ATTRIBUTE15 => lv_psd_rec.ATTRIBUTE15,
X_ATTRIBUTE16 => lv_psd_rec.ATTRIBUTE16,
X_ATTRIBUTE17 => lv_psd_rec.ATTRIBUTE17,
X_ATTRIBUTE18 => lv_psd_rec.ATTRIBUTE18,
X_ATTRIBUTE19 => lv_psd_rec.ATTRIBUTE19,
X_ATTRIBUTE20 => lv_psd_rec.ATTRIBUTE20);
Igs_Pe_Stat_Details_Pkg.update_row (
x_rowid => lv_psd_rec.rowid,
x_person_id => lv_psd_rec.person_id ,
x_effective_start_date => lv_psd_rec.effective_start_date,
x_effective_end_date => lv_psd_rec.effective_end_date,
x_religion_cd => lv_psd_rec.religion_cd,
x_socio_eco_cd => lv_psd_rec.socio_eco_cd,
x_next_to_kin => lv_psd_rec.next_to_kin,
x_in_state_tuition => lv_psd_rec.in_state_tuition,
x_tuition_st_date => lv_psd_rec.tuition_st_date,
x_tuition_end_date => lv_psd_rec.tuition_end_date,
x_further_education_cd => lv_psd_rec.further_education_cd,
X_MATR_CAL_TYPE => lv_psd_rec.MATR_CAL_TYPE,
X_MATR_SEQUENCE_NUMBER => lv_psd_rec.MATR_SEQUENCE_NUMBER,
X_INIT_CAL_TYPE => lv_psd_rec.INIT_CAL_TYPE,
X_INIT_SEQUENCE_NUMBER => lv_psd_rec.INIT_SEQUENCE_NUMBER,
X_RECENT_CAL_TYPE => lv_cttl_rec.load_cal_type,
X_RECENT_SEQUENCE_NUMBER => lv_cttl_rec.load_ci_sequence_number,
X_CATALOG_CAL_TYPE => lv_cttl_rec.load_cal_type ,
X_CATALOG_SEQUENCE_NUMBER => lv_cttl_rec.load_ci_sequence_number,
X_MODE => 'R',
X_ATTRIBUTE_CATEGORY => lv_psd_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => lv_psd_rec.ATTRIBUTE1,
X_ATTRIBUTE2 => lv_psd_rec.ATTRIBUTE2,
X_ATTRIBUTE3 => lv_psd_rec.ATTRIBUTE3,
X_ATTRIBUTE4 => lv_psd_rec.ATTRIBUTE4,
X_ATTRIBUTE5 => lv_psd_rec.ATTRIBUTE5,
X_ATTRIBUTE6 => lv_psd_rec.ATTRIBUTE6,
X_ATTRIBUTE7 => lv_psd_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => lv_psd_rec.ATTRIBUTE8,
X_ATTRIBUTE9 => lv_psd_rec.ATTRIBUTE9,
X_ATTRIBUTE10 => lv_psd_rec.ATTRIBUTE10,
X_ATTRIBUTE11 => lv_psd_rec.ATTRIBUTE11,
X_ATTRIBUTE12 => lv_psd_rec.ATTRIBUTE12,
X_ATTRIBUTE13 => lv_psd_rec.ATTRIBUTE13,
X_ATTRIBUTE14 => lv_psd_rec.ATTRIBUTE14,
X_ATTRIBUTE15 => lv_psd_rec.ATTRIBUTE15,
X_ATTRIBUTE16 => lv_psd_rec.ATTRIBUTE16,
X_ATTRIBUTE17 => lv_psd_rec.ATTRIBUTE17,
X_ATTRIBUTE18 => lv_psd_rec.ATTRIBUTE18,
X_ATTRIBUTE19 => lv_psd_rec.ATTRIBUTE19,
X_ATTRIBUTE20 => lv_psd_rec.ATTRIBUTE20);
Igs_Pe_Stat_Details_Pkg.update_row (
x_rowid => lv_psd_rec.rowid,
x_person_id => lv_psd_rec.person_id ,
x_effective_start_date => lv_psd_rec.effective_start_date,
x_effective_end_date => lv_psd_rec.effective_end_date,
x_religion_cd => lv_psd_rec.religion_cd,
x_socio_eco_cd => lv_psd_rec.socio_eco_cd,
x_next_to_kin => lv_psd_rec.next_to_kin,
x_in_state_tuition => lv_psd_rec.in_state_tuition,
x_tuition_st_date => lv_psd_rec.tuition_st_date,
x_tuition_end_date => lv_psd_rec.tuition_end_date,
x_further_education_cd => lv_psd_rec.further_education_cd,
X_MATR_CAL_TYPE => lv_psd_rec.MATR_CAL_TYPE,
X_MATR_SEQUENCE_NUMBER => lv_psd_rec.MATR_SEQUENCE_NUMBER,
X_INIT_CAL_TYPE => lv_psd_rec.INIT_CAL_TYPE,
X_INIT_SEQUENCE_NUMBER => lv_psd_rec.INIT_SEQUENCE_NUMBER,
X_RECENT_CAL_TYPE => lv_cttl_rec.load_cal_type,
X_RECENT_SEQUENCE_NUMBER => lv_cttl_rec.load_ci_sequence_number,
X_CATALOG_CAL_TYPE => lv_psd_rec.CATALOG_CAL_TYPE ,
X_CATALOG_SEQUENCE_NUMBER => lv_psd_rec.CATALOG_SEQUENCE_NUMBER,
X_MODE => 'R' ,
X_ATTRIBUTE_CATEGORY => lv_psd_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => lv_psd_rec.ATTRIBUTE1,
X_ATTRIBUTE2 => lv_psd_rec.ATTRIBUTE2,
X_ATTRIBUTE3 => lv_psd_rec.ATTRIBUTE3,
X_ATTRIBUTE4 => lv_psd_rec.ATTRIBUTE4,
X_ATTRIBUTE5 => lv_psd_rec.ATTRIBUTE5,
X_ATTRIBUTE6 => lv_psd_rec.ATTRIBUTE6,
X_ATTRIBUTE7 => lv_psd_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => lv_psd_rec.ATTRIBUTE8,
X_ATTRIBUTE9 => lv_psd_rec.ATTRIBUTE9,
X_ATTRIBUTE10 => lv_psd_rec.ATTRIBUTE10,
X_ATTRIBUTE11 => lv_psd_rec.ATTRIBUTE11,
X_ATTRIBUTE12 => lv_psd_rec.ATTRIBUTE12,
X_ATTRIBUTE13 => lv_psd_rec.ATTRIBUTE13,
X_ATTRIBUTE14 => lv_psd_rec.ATTRIBUTE14,
X_ATTRIBUTE15 => lv_psd_rec.ATTRIBUTE15,
X_ATTRIBUTE16 => lv_psd_rec.ATTRIBUTE16,
X_ATTRIBUTE17 => lv_psd_rec.ATTRIBUTE17,
X_ATTRIBUTE18 => lv_psd_rec.ATTRIBUTE18,
X_ATTRIBUTE19 => lv_psd_rec.ATTRIBUTE19,
X_ATTRIBUTE20 => lv_psd_rec.ATTRIBUTE20);