APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_CA_INST_REL

Line 1604: FROM igs_ca_inst_rel

1600: ******************************************************************/
1601:
1602: CURSOR c_acad_cal IS
1603: SELECT sup_ci_sequence_number
1604: FROM igs_ca_inst_rel
1605: WHERE sub_cal_type = p_load_cal AND
1606: sub_ci_sequence_number = p_load_ci_sequence_number AND
1607: sup_cal_type = p_acad_cal;
1608:

Line 1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;

1628: AND sua.ci_sequence_number = ltt.teach_ci_sequence_number
1629: AND ltt.load_cal_type = p_load_cal
1630: AND ltt.load_ci_sequence_number = p_load_ci_sequence_number ;
1631:
1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;
1633: l_commencement_type VARCHAR2(10);
1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;
1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;