eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_TIMESLOTS dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 373: FROM igs_ca_teach_to_load_v

369: l_chk_cal_cat igs_ca_type.s_cal_cat%TYPE;
370:
371: CURSOR c_teach_to_load IS
372: SELECT load_cal_type, load_ci_sequence_number
373: FROM igs_ca_teach_to_load_v
374: WHERE teach_cal_type = p_cal_type
375: AND teach_ci_sequence_number = p_seq_num
376: ORDER BY load_start_dt DESC;
377: l_load_cal_type igs_ca_teach_to_load_v.load_cal_type%TYPE;

Line 377: l_load_cal_type igs_ca_teach_to_load_v.load_cal_type%TYPE;

373: FROM igs_ca_teach_to_load_v
374: WHERE teach_cal_type = p_cal_type
375: AND teach_ci_sequence_number = p_seq_num
376: ORDER BY load_start_dt DESC;
377: l_load_cal_type igs_ca_teach_to_load_v.load_cal_type%TYPE;
378: l_load_ci_sequence_number igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE;
379:
380: CURSOR c_ps_att IS
381: SELECT course_cd, version_number, cal_type

Line 378: l_load_ci_sequence_number igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE;

374: WHERE teach_cal_type = p_cal_type
375: AND teach_ci_sequence_number = p_seq_num
376: ORDER BY load_start_dt DESC;
377: l_load_cal_type igs_ca_teach_to_load_v.load_cal_type%TYPE;
378: l_load_ci_sequence_number igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE;
379:
380: CURSOR c_ps_att IS
381: SELECT course_cd, version_number, cal_type
382: FROM IGS_EN_STDNT_PS_ATT sca