[Home] [Help]
4387: -- of any of the student's program attempts
4388: CURSOR c_check_is_load_assoc_to_acad (cp_person_id NUMBER, cp_load_cal_type VARCHAR2, cp_load_seq_num NUMBER) IS
4389: SELECT distinct cir.sub_cal_type ,cir.sub_ci_sequence_number
4390: FROM igs_en_stdnt_ps_att sca,
4391: igs_ca_inst_rel cir,
4392: igs_ca_type ct
4393: WHERE cir.sup_cal_type = sca.cal_type and
4394: ct.cal_type = cir.sub_cal_type and
4395: ct.s_cal_cat = 'LOAD' and