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_010 dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 6032: igs_ca_teach_to_load_v tl

6028: cp_load_ci_seq_num igs_ca_inst.sequence_number%TYPE)
6029: IS
6030: SELECT 'X'
6031: FROM igs_ps_unit_ofr_opt uoo,
6032: igs_ca_teach_to_load_v tl
6033: WHERE tl.teach_cal_type = uoo.cal_type
6034: AND tl.teach_ci_sequence_number = uoo.ci_sequence_number
6035: AND tl.load_cal_type = cp_load_cal_type
6036: AND tl.load_ci_sequence_number = cp_load_ci_seq_num

Line 8873: IGS_CA_TEACH_TO_LOAD_V tl

8869: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8870: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8871: SELECT load_cal_type, load_ci_sequence_number, load_start_dt, teach_cal_type, teach_ci_sequence_number
8872: FROM IGS_EN_SU_ATTEMPT sua,
8873: IGS_CA_TEACH_TO_LOAD_V tl
8874: WHERE sua.person_id = cp_person_id
8875: AND sua.course_cd = cp_source_course_cd
8876: AND sua.uoo_id = cp_uoo_id
8877: AND sua.cal_type = tl.teach_cal_type

Line 8902: FROM IGS_CA_TEACH_TO_LOAD_V

8898: cp_load_start_dt IGS_CA_INST.START_DT%TYPE,
8899: cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
8900: cp_teach_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
8901: SELECT load_cal_type, load_ci_sequence_number, load_start_dt
8902: FROM IGS_CA_TEACH_TO_LOAD_V
8903: WHERE cp_date between load_start_dt and load_end_dt
8904: AND load_start_dt >= cp_load_start_dt
8905: AND teach_cal_type = cp_teach_Cal_type
8906: AND teach_ci_sequence_number = cp_teach_sequence_number