APPS.IGS_EN_ENROLL_WLST dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 1512: FROM IGS_CA_TEACH_TO_LOAD_V

1508: -- cursor to fetch the First Load Calendar for the Teaching Calendar
1509: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,
1510: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1511: SELECT load_cal_type,load_ci_sequence_number
1512: FROM IGS_CA_TEACH_TO_LOAD_V
1513: WHERE teach_cal_type = p_cal_type AND
1514: teach_ci_sequence_number = p_sequence_number AND
1515: load_end_dt >= TRUNC(SYSDATE)
1516: ORDER BY load_start_dt;

Line 1726: FROM igs_ca_teach_to_load_v ctl,

1722: -- Cursor to get Load Calendar Type associated with a Unit Section. Enh Bug# 3052426 (ptandon)
1723: --
1724: CURSOR c_get_load_cal_type(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1725: SELECT ctl.load_cal_type
1726: FROM igs_ca_teach_to_load_v ctl,
1727: igs_ps_unit_ofr_opt uoo
1728: WHERE uoo.uoo_id = cp_uoo_id
1729: AND ctl.teach_cal_type = uoo.cal_type
1730: AND ctl.teach_ci_sequence_number = uoo.ci_sequence_number