APPS.IGS_SS_FACULTY_PKG dependencies on IGS_CA_INST

Line 78: CURSOR c_ci (cp_cal_type IGS_CA_INST.cal_type%TYPE,

74: AND course_cd = cp_course_cd
75: AND uoo_id = cp_uoo_id
76: ORDER BY outcome_dt ASC;
77:
78: CURSOR c_ci (cp_cal_type IGS_CA_INST.cal_type%TYPE,
79: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
80: SELECT start_dt,
81: end_dt
82: FROM IGS_CA_INST

Line 79: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

75: AND uoo_id = cp_uoo_id
76: ORDER BY outcome_dt ASC;
77:
78: CURSOR c_ci (cp_cal_type IGS_CA_INST.cal_type%TYPE,
79: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
80: SELECT start_dt,
81: end_dt
82: FROM IGS_CA_INST
83: WHERE cal_type = cp_cal_type

Line 82: FROM IGS_CA_INST

78: CURSOR c_ci (cp_cal_type IGS_CA_INST.cal_type%TYPE,
79: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
80: SELECT start_dt,
81: end_dt
82: FROM IGS_CA_INST
83: WHERE cal_type = cp_cal_type
84: AND sequence_number = cp_sequence_number;
85:
86: