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.IGF_AP_OSS_INTR_DTLS dependencies on IGS_EN_ATD_TYPE_LOAD

Line 327: SELECT attendance_type FROM igs_en_atd_type_load

323: AND base.base_id = p_base_id;
324:
325: -- Cursor to get the attendance type for the maximum enrollment load
326: CURSOR c_att_type(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS
327: SELECT attendance_type FROM igs_en_atd_type_load
328: WHERE cal_type = l_cal_type
329: AND lower_enr_load_range = (SELECT MAX(lower_enr_load_range)
330: FROM igs_en_atd_type_load
331: WHERE cal_type = l_cal_type);

Line 330: FROM igs_en_atd_type_load

326: CURSOR c_att_type(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS
327: SELECT attendance_type FROM igs_en_atd_type_load
328: WHERE cal_type = l_cal_type
329: AND lower_enr_load_range = (SELECT MAX(lower_enr_load_range)
330: FROM igs_en_atd_type_load
331: WHERE cal_type = l_cal_type);
332: l_full_att c_att_type%ROWTYPE;
333:
334: CURSOR c_get_base_id (cp_person_id igf_ap_fa_base_rec.person_id%TYPE,