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

Line 399: SELECT load_cal_type, load_ci_sequence_number FROM igs_ca_teach_to_load_v

395: SELECT 1 FROM igs_ps_unit_ofr_opt
396: WHERE uoo_id = cp_uoo_id FOR UPDATE;
397: CURSOR cur_load(cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
398: cp_teach_ci_sequence_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
399: SELECT load_cal_type, load_ci_sequence_number FROM igs_ca_teach_to_load_v
400: WHERE teach_cal_type = cp_teach_cal_type
401: AND teach_ci_sequence_number = cp_teach_ci_sequence_num
402: ORDER BY load_start_dt ASC;
403:

Line 1283: FROM igs_ca_teach_to_load_v

1279: AND closed_flag = 'N';
1280:
1281: CURSOR cur_cal_info IS
1282: SELECT load_ci_sequence_number, load_cal_type
1283: FROM igs_ca_teach_to_load_v
1284: WHERE teach_cal_type = NVL(old_references.cal_type, new_references.cal_type)
1285: AND teach_ci_sequence_number = NVL(old_references.ci_sequence_number,new_references.ci_sequence_number)
1286: ORDER BY load_start_dt ASC;
1287:

Line 2515: FROM IGS_CA_TEACH_TO_LOAD_V ttl,

2511: -- find all term calendars assiciated with the teach calendar of the unit and subordinate to any instance
2512: -- of the academic calendar of the student program attempt.
2513: CURSOR c_teach_to_load(cp_acad_cal_type VARCHAR2) IS
2514: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number
2515: FROM IGS_CA_TEACH_TO_LOAD_V ttl,
2516: IGS_EN_STDNT_PS_ATT spa,
2517: IGS_CA_INST_REL cir
2518: WHERE ttl.teach_cal_type= new_references.cal_type
2519: AND ttl.teach_ci_sequence_number = new_references.ci_sequence_number