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_GEN_016 dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 110: FROM igs_en_su_attempt_all sua , igs_ca_load_to_teach_v calt

106: -- cursor to get all Unit Attempts whose Teaching Calendar fall within the given Load Calendar
107: --
108: CURSOR get_sua (p_person_id IN NUMBER , p_course_cd IN VARCHAR2, p_load_cal_type IN VARCHAR2 , p_load_ci_sequence_number IN NUMBER ) IS
109: SELECT sua.uoo_id , sua.unit_cd , sua.version_number , sua.cal_type , sua.ci_sequence_number
110: FROM igs_en_su_attempt_all sua , igs_ca_load_to_teach_v calt
111: where sua.unit_attempt_status = 'UNCONFIRM'
112: AND sua.course_cd = p_course_cd
113: AND sua.cal_type = calt.teach_cal_type
114: AND sua.person_id = p_person_id