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

Line 382: FROM igs_ca_load_to_teach_v

378: WHERE person_id = cp_person_id
379: AND unit_attempt_status IN ('INVALID','WAITLIST','ENROLLED')
380: AND course_cd = cp_course_cd
381: AND (cal_type , ci_sequence_number) IN (SELECT teach_cal_type,teach_ci_sequence_number
382: FROM igs_ca_load_to_teach_v
383: WHERE load_cal_type = cp_cal_type AND
384: load_ci_sequence_number = cp_ci_sequence_number);
385: l_rec_uoo_id cur_uoo_id%ROWTYPE;
386: l_uoo_ids VARCHAR2(1000);

Line 873: FROM igs_ca_load_to_teach_v

869: FROM igs_ps_unit_ofr_opt
870: WHERE call_number = p_call_number
871: AND ( cal_type, ci_sequence_number ) IN
872: ( SELECT teach_cal_type, teach_ci_sequence_number
873: FROM igs_ca_load_to_teach_v
874: WHERE load_cal_type = cp_cal_type
875: AND load_ci_sequence_number = cp_ci_seq_num );
876:
877: BEGIN