APPS.IGS_SS_ENROLL_PKG dependencies on IGS_CA_INST_REL

Line 575: igs_ca_inst_rel cir,

571: -- Get the first Term calendar
572: CURSOR c_first_term_acad(cp_acad_cal_type VARCHAR2,cp_acad_ci_sequence_number NUMBER) IS
573: SELECT ci.sequence_number||ci.cal_type
574: FROM igs_ca_inst ci,
575: igs_ca_inst_rel cir,
576: igs_ca_type ct,
577: igs_ca_stat cs
578: WHERE ci.cal_type = cir.sub_cal_type AND
579: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 685: igs_ca_inst_rel cir,

681: -- Get the first Term calendar
682: CURSOR c_first_term_acad(cp_acad_cal_type VARCHAR2,cp_acad_ci_sequence_number NUMBER) IS
683: SELECT ci.start_dt
684: FROM igs_ca_inst ci,
685: igs_ca_inst_rel cir,
686: igs_ca_type ct,
687: igs_ca_stat cs
688: WHERE ci.cal_type = cir.sub_cal_type AND
689: ci.sequence_number = cir.sub_ci_sequence_number AND