APPS.IGS_EN_SEVIS dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 146: FROM IGS_CA_TEACH_TO_LOAD_V

142: -- Cursor to get the corresponding load calander for the passed teaching calander
143: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,
144: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
145: SELECT load_cal_type,load_ci_sequence_number
146: FROM IGS_CA_TEACH_TO_LOAD_V
147: WHERE teach_cal_type = p_cal_type AND
148: teach_ci_sequence_number = p_sequence_number AND
149: load_end_dt >= TRUNC(SYSDATE)
150: ORDER BY load_start_dt asc;