[Home] [Help]
113: SELECT lci.cal_type,
114: lci.sequence_number
115: FROM IGS_CA_INST_REL acir,
116: IGS_CA_INST aci,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,
120: IGS_CA_INST lci,
121: IGS_CA_TYPE lcat,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,
120: IGS_CA_INST lci,
121: IGS_CA_TYPE lcat,
122: IGS_CA_STAT lcs
123: WHERE acir.sub_cal_type = p_teach_cal_type AND
124: acir.sub_ci_sequence_number = p_teach_sequence_number AND
125: aci.cal_type = acir.sup_cal_type AND
1072: SELECT CI.cal_type,
1073: CI.sequence_number
1074: FROM IGS_CA_INST_REL CIR,
1075: IGS_CA_INST CI,
1076: IGS_CA_TYPE CT,
1077: IGS_CA_STAT CS
1078: WHERE CT.closed_ind = 'N' AND
1079: CT.s_cal_cat = cst_teaching AND
1080: CS.s_cal_status = cst_active AND
1348: v_record_found BOOLEAN;
1349: v_record_count NUMBER;
1350: v_attendance_type IGS_EN_ATD_TYPE_LOAD.attendance_type%TYPE;
1351: CURSOR c_attendance_type(
1352: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
1353: cp_load_figure IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE) IS
1354: SELECT ATL.attendance_type
1355: FROM IGS_EN_ATD_TYPE_LOAD ATL
1356: WHERE ATL.cal_type = p_load_cal_type AND
1618: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'
1621: FROM IGS_CA_INST_REL cir1,
1622: IGS_CA_TYPE ct,
1623: IGS_CA_INST_REL cir2
1624: WHERE cir1.sub_cal_type = cp_load_cal_type AND
1625: cir1.sub_ci_sequence_number = cp_load_sequence_number AND
1626: ct.cal_type = cir1.sup_cal_type AND
2265: Attendance type for a student, course and academic or load calendar
2266: ***********************************************************************************************************************/
2267: CURSOR c_cal_cat IS
2268: SELECT S_CAL_CAT
2269: FROM igs_ca_type
2270: WHERE cal_type = p_cal_type;
2271:
2272: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2273:
2268: SELECT S_CAL_CAT
2269: FROM igs_ca_type
2270: WHERE cal_type = p_cal_type;
2271:
2272: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2273:
2274: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2275: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2276:
2452: Purpose : SS Worksheet Redesign
2453: ***********************************************************************************************************************/
2454: CURSOR c_cal_cat IS
2455: SELECT S_CAL_CAT
2456: FROM igs_ca_type
2457: WHERE cal_type = p_cal_type;
2458:
2459: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2460: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2455: SELECT S_CAL_CAT
2456: FROM igs_ca_type
2457: WHERE cal_type = p_cal_type;
2458:
2459: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2460: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2461: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2462: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2463: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;