[Home] [Help]
72: sca.course_cd = p_course_cd;
73: CURSOR c_cir IS
74: SELECT cir.sup_cal_type,
75: cir.sup_ci_sequence_number
76: FROM IGS_CA_INST_REL cir,
77: IGS_CA_INST ci,
78: IGS_CA_TYPE ct,
79: IGS_CA_STAT cs
80: WHERE cir.sub_cal_type = p_cal_type AND
2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN
2890: --
2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';
2892: --
2893: -- Append Person ID Group filter to the Where clause only when it is passed
2894: --
2895: IF (p_group_id IS NOT NULL) THEN
3211: ci1.start_dt >=
3212: -- On or after the first progression period linked to the student unit
3213: -- attempt
3214: (SELECT MIN(ci2.start_dt)
3215: FROM IGS_CA_INST_REL cir,
3216: IGS_CA_INST ci2,
3217: IGS_CA_STAT cs,
3218: IGS_CA_TYPE cat
3219: WHERE cir.sub_cal_type = cp_cal_type AND
4836: CURSOR c_cir IS
4837: SELECT cir.sub_cal_type,
4838: cir.sub_ci_sequence_number
4839: FROM IGS_CA_INST ci,
4840: IGS_CA_INST_REL cir,
4841: IGS_CA_TYPE cat,
4842: IGS_CA_STAT cs
4843: WHERE cir.sup_cal_type = p_prg_cal_type AND
4844: cir.sup_ci_sequence_number = p_prg_sequence_number AND
4921: CURSOR c_cir IS
4922: SELECT cir.sub_cal_type,
4923: cir.sub_ci_sequence_number
4924: FROM IGS_CA_INST ci,
4925: IGS_CA_INST_REL cir,
4926: IGS_CA_TYPE cat,
4927: IGS_CA_STAT cs
4928: WHERE cir.sup_cal_type = p_prg_cal_type AND
4929: cir.sup_ci_sequence_number = p_prg_sequence_number AND
5031: CURSOR c_cir IS
5032: SELECT cir.sub_cal_type,
5033: cir.sub_ci_sequence_number
5034: FROM IGS_CA_INST ci,
5035: IGS_CA_INST_REL cir,
5036: IGS_CA_TYPE cat,
5037: IGS_CA_STAT cs
5038: WHERE cir.sup_cal_type = p_prg_cal_type AND
5039: cir.sup_ci_sequence_number = p_prg_sequence_number AND