[Home] [Help]
32: -- Research IGS_PS_UNIT AOU?s are defined by the links with their supervisors (or
33: -- if not specified, by the standards means).
34: DECLARE
35: CURSOR c_rsup (
36: cp_census_dt IGS_CA_DA_INST.absolute_val%TYPE)
37: IS
38: SELECT rsup.org_unit_cd,
39: rsup.ou_start_dt,
40: sum(rsup.funding_percentage) sum_fund_perc
61: dai.cal_type,
62: dai.ci_sequence_number)) census_dt
63: FROM IGS_PS_UNIT_OFR_OPT uoo,
64: IGS_GE_S_GEN_CAL_CON sgcc,
65: IGS_CA_DA_INST dai
66: WHERE uoo.uoo_id = p_uoo_id AND
67: sgcc.s_control_num = 1 and
68: dai.dt_alias = sgcc.census_dt_alias AND
69: dai.cal_type = uoo.cal_type AND
68: dai.dt_alias = sgcc.census_dt_alias AND
69: dai.cal_type = uoo.cal_type AND
70: dai.ci_sequence_number = uoo.ci_sequence_number
71: ORDER BY census_dt;
72: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
73: v_eftsu_total NUMBER;
74: -- So I can test whether any records were found for statement 2
75: v_records_found BOOLEAN := FALSE;
76: BEGIN
780: -- ? A student is only ever enrolled in a single research IGS_PS_UNIT within a load
781: -- calendar (ie. multiple units are not taken into consideration when
782: -- comparing the research load with the coursework load).
783: DECLARE
784: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
785: v_ca_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
786: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;
788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
839: dai.sequence_number,
840: dai.cal_type,
841: dai.ci_sequence_number)) v_census_dt
842: FROM IGS_GE_S_GEN_CAL_CON sgcc,
843: IGS_CA_DA_INST dai
844: WHERE sgcc.s_control_num = 1 AND
845: dai.cal_type = cp_cal_type AND
846: dai.ci_sequence_number = cp_ci_sequence_number AND
847: dai.dt_alias = sgcc.census_dt_alias