APPS.IGS_EN_PRC_LOAD dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 266: FROM igs_ca_load_to_teach_v

262: WHERE sca.person_id = p_person_id AND
263: sca.course_cd = p_course_cd;
264: CURSOR c_load_to_teach IS
265: SELECT teach_cal_type, teach_ci_sequence_number
266: FROM igs_ca_load_to_teach_v
267: WHERE load_cal_type = p_load_cal_type
268: AND load_ci_sequence_number = p_load_sequence_number;
269:
270: CURSOR c_sua_cir(cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_num igs_ca_inst.sequence_number%TYPE) IS

Line 2151: FROM IGS_CA_LOAD_TO_TEACH_V lt

2147: cp_load_seq_num igs_ca_inst.sequence_number%TYPE,
2148: cp_tp_sd_cut_off_date DATE) IS
2149: SELECT teach_cal_type,
2150: teach_ci_sequence_number
2151: FROM IGS_CA_LOAD_TO_TEACH_V lt
2152: WHERE lt.load_cal_type = cp_load_cal_type
2153: AND lt.load_ci_sequence_number = cp_load_seq_num
2154: AND lt.teach_start_dt <= cp_tp_sd_cut_off_date
2155: ORDER BY teach_cal_type ASC,teach_ci_sequence_number ASC;