APPS.IGS_SS_ENR_DETAILS dependencies on IGS_CA_TYPE

Line 2323: l_enrol_cal_type igs_ca_type.cal_type%TYPE;

2319: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2320: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2321: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2322: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2323: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2324: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2325: l_message VARCHAR2(300);
2326: l_ret_status VARCHAR2(30);
2327: l_dummy VARCHAR2(300);

Line 4392: igs_ca_type ct

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
4396: sca.person_id = cp_person_id and