[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sle.text
FROM IGS_GE_S_LOG_ENTRY sle,
IGS_GE_S_LOG sl
WHERE sl.key = p_key AND
sl.s_log_type = p_log_type AND
sle.s_log_type = sl.s_log_type AND
sle.creation_dt = sl.creation_dt
ORDER BY sle.sequence_number;
SELECT IGS_EN_GEN_014.enrs_get_acad_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
||'/'|| IGS_CA_GEN_001.calp_get_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
FROM IGS_EN_SU_ATTEMPT SUAV,
IGS_CA_INST CI
WHERE SUAV.person_id = cp_person_id AND
SUAV.course_cd = cp_course_cd AND
SUAV.enrolled_dt IS NOT NULL AND
SUAV.cal_type = CI.cal_type AND
SUAV.ci_sequence_number = CI.sequence_number
ORDER BY CI.start_dt,
CI.end_dt ;
SELECT cat.s_cal_cat
FROM IGS_CA_TYPE cat
WHERE cat.cal_type = cp_cal_type;
SELECT cir.sup_cal_type,
cir.sup_ci_sequence_number,
ci.start_dt,
ci.end_dt,
ci.alternate_code
FROM IGS_CA_INST_REL cir,
IGS_CA_INST ci,
IGS_CA_TYPE cat
WHERE cir.sub_cal_type = cp_cal_type AND
cir.sub_ci_sequence_number = cp_ci_sequence_number AND
ci.cal_type = cir.sup_cal_type AND
ci.sequence_number = cir.sup_ci_sequence_number AND
cat.cal_type = ci.cal_type AND
cat.s_cal_cat = 'ACADEMIC'
ORDER BY
ci.start_dt asc,
ci.end_dt asc;
SELECT cir.sup_cal_type,
cir.sup_ci_sequence_number,
ci.start_dt,
ci.end_dt,
ci.alternate_code,
cat.s_cal_cat
FROM IGS_CA_INST_REL cir,
IGS_CA_INST ci,
IGS_CA_TYPE cat
WHERE cir.sub_cal_type = cp_cal_type AND
cir.sub_ci_sequence_number = cp_ci_sequence_number AND
ci.cal_type = cir.sup_cal_type AND
ci.sequence_number = cir.sup_ci_sequence_number AND
cat.cal_type = ci.cal_type
ORDER BY
ci.start_dt asc,
ci.end_dt asc;
SELECT MIN(sca.commencement_dt) commencement_dt
FROM IGS_PS_STDNT_TRN sct,
IGS_EN_STDNT_PS_ATT sca,
IGS_PS_VER crv
WHERE sct.person_id = p_person_id AND
sct.course_cd = p_course_cd AND
sct.person_id = sca.person_id AND
sct.transfer_course_cd = sca.course_cd AND
crv.course_cd = sca.course_cd AND
crv.version_number = sca.version_number AND
crv.generic_course_ind = 'Y';
SELECT MIN(IGS_CA_GEN_001.calp_set_alias_value
(
daiv.absolute_val,
IGS_CA_GEN_002.cals_clc_dt_from_dai
(
daiv.ci_sequence_number,
daiv.CAL_TYPE,
daiv.DT_ALIAS,
daiv.sequence_number
)
)
) alias_val
FROM IGS_CA_DA_INST daiv,
IGS_EN_CAL_CONF secc
WHERE daiv.cal_type = cp_acad_cal_type AND
daiv.ci_sequence_number = cp_acad_ci_sequence_number AND
secc.commencement_dt_alias = daiv.dt_alias AND
secc.s_control_num = 1;
SELECT NVL(acai.adm_cal_type, aa.adm_cal_type) adm_cal_type,
NVL(acai.adm_ci_sequence_number, aa.adm_ci_sequence_number) adm_ci_sequence_number,
acai.prpsd_commencement_dt prpsd_commencement_dt
FROM
IGS_AD_PS_APPL_INST acai,
IGS_AD_APPL aa,
IGS_CA_INST ci,
IGS_AD_PS_APPL aca,
IGS_PS_VER crv
WHERE acai.person_id = p_person_id AND
aa.person_id = acai.person_id AND
acai.admission_appl_number = p_adm_admission_appl_number AND
aa.admission_appl_number = acai.admission_appl_number AND
ci.cal_type (+) = acai.deferred_adm_cal_type AND
ci.sequence_number (+) = acai.deferred_adm_ci_sequence_num AND
aca.person_id = acai.person_id AND
aca.admission_appl_number = acai.admission_appl_number AND
acai.nominated_course_cd = p_adm_nominated_course_cd AND
aca.nominated_course_cd = acai.nominated_course_cd AND
crv.course_cd = acai.course_cd AND
crv.version_number = acai.crv_version_number AND
acai.sequence_number = p_adm_sequence_number;
SELECT aa.s_admission_process_type
FROM IGS_AD_APPL aa
WHERE person_id = p_person_id AND
admission_appl_number = p_adm_admission_appl_number;
SELECT cir.sup_cal_type,
cir.sup_ci_sequence_number
FROM IGS_AS_SC_ATMPT_ENR scae,
IGS_CA_INST_REL cir,
IGS_CA_INST ci,
IGS_CA_TYPE cat
WHERE scae.person_id = p_person_id AND
scae.course_cd = p_course_cd AND
scae.cal_type = cir.sub_cal_type AND
scae.ci_sequence_number = cir.sub_ci_sequence_number AND
cir.sub_cal_type = ci.cal_type AND
cir.sub_ci_sequence_number = ci_sequence_number AND
cir.sup_cal_type = cat.cal_type AND
cat.s_cal_cat = cst_academic
ORDER BY ci.start_dt ASC;
SELECT attendance_type
FROM IGS_EN_ATD_TYPE
WHERE lower_enr_load_range <= p_load_figure AND
upper_enr_load_range >= p_load_figure AND
lower_enr_load_range <> 0 AND -- testing for non zero ensures a
upper_enr_load_range <> 0; -- valid derivable load range has
SELECT s_adm_outcome_status
FROM IGS_AD_OU_STAT aos
WHERE adm_outcome_status = p_adm_outcome_status;
SELECT s_adm_offer_resp_status
FROM IGS_AD_OFR_RESP_STAT aors
WHERE adm_offer_resp_status = p_adm_offer_resp_status;
-- Select the system offer response status. Check that it hasn't lapsed or been rejected.
OPEN c_aors;
SELECT atl.default_eftsu
FROM IGS_EN_ATD_TYPE_LOAD atl
WHERE atl.cal_type = p_load_cal_type AND
atl.attendance_type = p_attendance_type;
SELECT annual_load_val
FROM IGS_PS_ANL_LOAD cal
WHERE cal.course_cd = p_course_cd AND
cal.version_number = p_version_number
ORDER BY yr_num ASC;
SELECT std_annual_load
FROM IGS_PS_VER crv
WHERE crv.course_cd = p_course_cd AND
crv.version_number = p_version_number;
--Select detail from default load apportion
OPEN c_atl;
SELECT 'x'
FROM IGS_AS_SC_ATMPT_NOTE scan
WHERE scan.person_id = p_person_id AND
Course_cd = p_course_cd;
SELECT 'x'
FROM IGS_AS_SU_SETATMPT susa
WHERE susa.person_id = p_person_id AND
susa.course_cd = p_course_cd AND
susa.student_confirmed_ind = 'Y' AND
susa.end_dt IS NULL;
SELECT 'x'
FROM IGS_EN_STDNTPSHECSOP scho
WHERE scho.person_id = p_person_id AND
scho.course_cd = p_course_cd AND
scho.start_dt <= p_effective_dt AND
(scho.end_dt IS NULL OR
scho.end_dt > p_effective_dt);
SELECT 'x'
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
ca.sca_course_cd = p_course_cd;
SELECT 'x'
FROM IGS_AS_SC_ATMPT_ENR scae
WHERE scae.person_id = p_person_id AND
scae.course_cd = p_course_cd AND
IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
p_acad_cal_type,
p_acad_sequence_number,
scae.cal_type,
scae.ci_sequence_number,
'N') = 'Y';