[Home] [Help]
252: v_sca_total_cp NUMBER;
253: v_eftsu_total NUMBER;
254: v_cp_total NUMBER;
255: v_sua_cp NUMBER;
256: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
257: v_sca_total_calculated BOOLEAN;
258:
259: CURSOR c_sca IS
260: SELECT sca.version_number
309: dai.sequence_number,
310: dai.cal_type,
311: dai.ci_sequence_number)) AS census_dt
312: FROM IGS_GE_S_GEN_CAL_CON sgcc,
313: IGS_CA_DA_INST dai
314: WHERE sgcc.s_control_num = 1 AND
315: dai.cal_type = cp_cal_type AND
316: dai.ci_sequence_number = cp_ci_sequence_number AND
317: dai.dt_alias = sgcc.census_dt_alias
875: v_std_annual_load IGS_PS_VER.std_annual_load%TYPE;
876: v_annual_load_val IGS_PS_ANL_LOAD.annual_load_val%TYPE;
877: v_sca_cp_total NUMBER;
878: v_cumulative_load NUMBER;
879: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
880: CURSOR c_cal IS
881: SELECT COUNT(*)
882: FROM IGS_PS_ANL_LOAD cal
883: WHERE cal.course_cd = p_course_cd AND
923: dai.sequence_number,
924: dai.cal_type,
925: dai.ci_sequence_number)) AS census_dt
926: FROM IGS_GE_S_GEN_CAL_CON sgcc,
927: IGS_CA_DA_INST dai
928: WHERE sgcc.s_control_num = 1 AND
929: dai.dt_alias = sgcc.census_dt_alias AND
930: dai.cal_type = p_cal_type AND
931: dai.ci_sequence_number = p_ci_sequence_number
1467: CURSOR incl_inst_wlst_cp is
1468: SELECT include_waitlist_cp_flag
1469: FROM IGS_EN_INST_WL_STPS;
1470:
1471: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1472: v_load_incurred_ind IGS_AD_ADM_UT_STT_LD.load_incurred_ind%TYPE;
1473: v_start_dt IGS_CA_INST.start_dt%TYPE;
1474: v_end_dt IGS_CA_INST.end_dt%TYPE;
1475: v_dummy_aus VARCHAR2(10);
2377: ***********************************************************************************************************************/
2378: CURSOR c_latest_load IS
2379: SELECT rel.SUB_CAL_TYPE , rel.SUB_CI_SEQUENCE_NUMBER , NVL(dai.absolute_val, cai.start_dt) load_effective_dt
2380: FROM igs_ca_inst_rel rel,
2381: igs_ca_da_inst dai,
2382: igs_en_cal_conf conf,
2383: igs_ca_inst cai
2384: WHERE
2385: rel.SUB_CAL_TYPE = dai.CAL_TYPE