APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 267: FROM IGS_CA_TEACH_TO_LOAD_V

263: ORDER BY discontinued_dt DESC;
264:
265: CURSOR cur_term_cal(p_cal_type VARCHAR2,p_ci_sequence_number NUMBER, p_discontinued_dt DATE) IS
266: SELECT *
267: FROM IGS_CA_TEACH_TO_LOAD_V
268: WHERE teach_cal_type = p_cal_type
269: AND teach_ci_sequence_number = p_ci_sequence_number
270: AND load_start_dt <= TRUNC(p_discontinued_dt)
271: ORDER BY load_start_dt DESC;

Line 283: FROM IGS_CA_TEACH_TO_LOAD_V

279:
280:
281: CURSOR cur_term_cal_grd(p_cal_type VARCHAR2,p_ci_sequence_number NUMBER) IS
282: SELECT *
283: FROM IGS_CA_TEACH_TO_LOAD_V
284: WHERE teach_cal_type = p_cal_type
285: AND teach_ci_sequence_number = p_ci_sequence_number
286: ORDER BY load_end_dt DESC;
287:

Line 288: lv_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE;

284: WHERE teach_cal_type = p_cal_type
285: AND teach_ci_sequence_number = p_ci_sequence_number
286: ORDER BY load_end_dt DESC;
287:
288: lv_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE;
289: lv_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE;
290: lv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
291:
292: cur_unit_atmpt_dis_rec cur_unit_atmpt_dis%ROWTYPE;

Line 289: lv_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE;

285: AND teach_ci_sequence_number = p_ci_sequence_number
286: ORDER BY load_end_dt DESC;
287:
288: lv_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE;
289: lv_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE;
290: lv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
291:
292: cur_unit_atmpt_dis_rec cur_unit_atmpt_dis%ROWTYPE;
293: cur_term_cal_rec cur_term_cal%ROWTYPE;