[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rsup.org_unit_cd,
rsup.ou_start_dt,
sum(rsup.funding_percentage) sum_fund_perc
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.funding_percentage IS NOT NULL AND
rsup.funding_percentage > 0 AND
rsup.start_dt <= cp_census_dt AND
(rsup.end_dt IS NULL OR
rsup.end_dt >= cp_census_dt)
GROUP BY
rsup.org_unit_cd,
rsup.ou_start_dt;
SELECT udis.percentage
FROM IGS_PS_UNIT_DSCP udis
WHERE udis.unit_cd = p_unit_cd AND
udis.version_number = p_version_number;
SELECT NVL(dai.absolute_val, IGS_CA_GEN_001.calp_get_alias_val(
dai.dt_alias,
dai.sequence_number,
dai.cal_type,
dai.ci_sequence_number)) census_dt
FROM IGS_PS_UNIT_OFR_OPT uoo,
IGS_GE_S_GEN_CAL_CON sgcc,
IGS_CA_DA_INST dai
WHERE uoo.uoo_id = p_uoo_id AND
sgcc.s_control_num = 1 and
dai.dt_alias = sgcc.census_dt_alias AND
dai.cal_type = uoo.cal_type AND
dai.ci_sequence_number = uoo.ci_sequence_number
ORDER BY census_dt;
SELECT cir.load_research_percentage
FROM IGS_CA_INST_REL cir
WHERE sup_cal_type = p_acad_cal_type AND
sup_ci_sequence_number = p_acad_ci_sequence_number AND
sub_cal_type = p_load_cal_type AND
sub_ci_sequence_number = p_load_ci_sequence_number;
SELECT ca.acai_admission_appl_number,
ca.acai_nominated_course_cd,
ca.acai_sequence_number,
ca.sca_course_cd,
ca.attendance_percentage
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
ca.sequence_number = p_ca_sequence_number;
SELECT sca.course_cd,
sca.version_number,
sca.attendance_type,
sca.commencement_dt,
sca.course_attempt_status
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = v_ca_sca_course_cd;
SELECT acai.course_cd,
acai.crv_version_number,
acai.attendance_type
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
acai.admission_appl_number = v_ca_acai_adm_appl_number AND
acai.nominated_course_cd = v_ca_acai_nominated_course_cd AND
acai.sequence_number = v_ca_acai_sequence_number AND
aa.person_id = acai.person_id 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
aca.nominated_course_cd = acai.nominated_course_cd AND
crv.course_cd = acai.course_cd AND
crv.version_number = acai.crv_version_number;
SELECT att.research_percentage
FROM IGS_EN_ATD_TYPE att
WHERE att.attendance_type = NVL(v_sca_attendance_type,v_acai_attendance_type);
SELECT ca.acai_admission_appl_number,
ca.acai_nominated_course_cd,
ca.acai_sequence_number,
ca.sca_course_cd,
ca.attendance_percentage
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
ca.sequence_number = p_ca_sequence_number;
SELECT sca.course_cd,
sca.version_number,
sca.attendance_type,
sca.commencement_dt,
sca.course_attempt_status
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = v_ca_sca_course_cd;
SELECT acai.course_cd,
acai.crv_version_number,
acai.attendance_type
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
acai.admission_appl_number = v_ca_acai_adm_appl_number AND
acai.nominated_course_cd = v_ca_acai_nominated_course_cd AND
acai.sequence_number = v_ca_acai_sequence_number AND
aa.person_id = acai.person_id 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
aca.nominated_course_cd = acai.nominated_course_cd AND
crv.course_cd = acai.course_cd AND
crv.version_number = acai.crv_version_number;
SELECT crv.min_sbmsn_percentage
FROM IGS_PS_VER crv
WHERE crv.course_cd = NVL(
v_sca_course_cd,
v_acai_course_cd) AND
crv.version_number = NVL(
v_sca_version_number,
v_acai_version_number);
SELECT att.research_percentage
FROM IGS_EN_ATD_TYPE att
WHERE att.attendance_type = NVL(
v_sca_attendance_type,
v_acai_attendance_type);
SELECT ca.person_id,
ca.sequence_number
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
NVL(ca.sca_course_cd, 'NULL') = NVL(p_course_cd, 'NULL');
SELECT sua.override_eftsu,
sua.cal_type,
sua.ci_sequence_number,
sua.uoo_id,
sua.version_number
FROM IGS_EN_SU_ATTEMPT sua,
IGS_EN_STDNT_PS_ATT sca,
IGS_PS_UNIT_VER uv
WHERE sua.person_id = cp_person_id AND
sua.course_cd = cp_course_cd AND
sua.uoo_id = cp_uoo_id AND
sca.person_id = sua.person_id AND
sca.course_cd = sua.course_cd AND
uv.unit_cd = sua.unit_cd AND
uv.version_number = sua.version_number AND
uv.research_unit_ind = 'Y';
SELECT NVL(
dai.absolute_val,
IGS_CA_GEN_001.calp_get_alias_val(
dai.dt_alias,
dai.sequence_number,
dai.cal_type,
dai.ci_sequence_number)) v_census_dt
FROM IGS_GE_S_GEN_CAL_CON sgcc,
IGS_CA_DA_INST dai
WHERE sgcc.s_control_num = 1 AND
dai.cal_type = cp_cal_type AND
dai.ci_sequence_number = cp_ci_sequence_number AND
dai.dt_alias = sgcc.census_dt_alias
ORDER BY 1;
SELECT ca.sequence_number,
ca.attendance_percentage
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
(ca.sca_course_cd IS NULL OR
ca.sca_course_cd = p_course_cd);
SELECT sca.course_attempt_status,
sca.commencement_dt,
sca.attendance_type,
sca.version_number
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_course_cd;
SELECT cah.hist_start_dt,
cah.hist_end_dt,
cah.attendance_percentage
FROM IGS_RE_CDT_ATT_HIST cah
WHERE cah.person_id = p_person_id AND
cah.ca_sequence_number = cp_sequence_number
ORDER BY cah.hist_start_dt ASC;
SELECT att.research_percentage
FROM IGS_EN_ATD_TYPE att
WHERE att.attendance_type = cp_attendance_type AND
att.closed_ind = 'N';
SELECT crv.count_intrmsn_in_time_ind
FROM IGS_PS_VER crv
WHERE crv.course_cd = p_course_cd AND
crv.version_number = cp_version_number;
SELECT sci.start_dt,
sci.end_dt
FROM IGS_EN_STDNT_PS_INTM sci,
IGS_EN_INTM_TYPES eit
WHERE sci.person_id = p_person_id AND
sci.course_cd = p_course_cd AND
sci.approved = eit.appr_reqd_ind AND
eit.intermission_type = sci.intermission_type AND
sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
ORDER BY sci.start_dt;
SELECT cah.hist_start_dt,
cah.hist_end_dt,
cah.attendance_percentage
FROM IGS_RE_CDT_ATT_HIST cah
WHERE cah.person_id = p_person_id AND
cah.ca_sequence_number = cp_sequence_number AND
cah.hist_start_dt <= cp_sci_end_dt AND
cah.hist_end_dt >= cp_sci_start_dt
ORDER BY cah.hist_start_dt ASC;
SELECT ca.sequence_number,
ca.attendance_percentage,
sca.attendance_type
FROM IGS_RE_CANDIDATURE ca,
IGS_EN_STDNT_PS_ATT sca
WHERE ca.person_id = p_person_id AND
ca.sca_course_cd = p_course_cd AND
sca.course_cd = ca.sca_course_cd AND
sca.person_id = ca.person_id;
SELECT cah.attendance_type,
cah.attendance_percentage
FROM IGS_RE_CDT_ATT_HIST cah
WHERE cah.person_id = cp_person_id AND
cah.ca_sequence_number = cp_ca_sequence_number AND
cah.hist_end_dt >= cp_effective_dt
ORDER BY cah.hist_start_dt ASC;
SELECT att.research_percentage
FROM IGS_EN_ATD_TYPE att
WHERE att.attendance_type = cp_attendance_type;
SELECT sca.commencement_dt
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_sca_course_cd;