DBA Data[Home] [Help]

APPS.IGS_SS_ENROLL_PKG dependencies on IGS_CA_TYPE

Line 576: igs_ca_type ct,

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
580: ci.cal_type = ct.cal_type AND

Line 686: igs_ca_type ct,

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
690: ci.cal_type = ct.cal_type AND