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

Line 772: CURSOR c_cttl(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE,

768: WHERE pv.course_type = pt.course_type AND
769: pv.course_cd = cp_course_cd AND
770: pv.version_number = cp_version_number ;
771: lv_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
772: CURSOR c_cttl(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE,
773: cp_teach_ci_seq_num IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE) IS
774: Select load_cal_type,
775: load_ci_sequence_number
776: FROM IGS_CA_TEACH_TO_LOAD_V

Line 773: cp_teach_ci_seq_num IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE) IS

769: pv.course_cd = cp_course_cd AND
770: pv.version_number = cp_version_number ;
771: lv_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
772: CURSOR c_cttl(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE,
773: cp_teach_ci_seq_num IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE) IS
774: Select load_cal_type,
775: load_ci_sequence_number
776: FROM IGS_CA_TEACH_TO_LOAD_V
777: WHERE teach_cal_type = cp_teach_cal_type AND

Line 776: FROM IGS_CA_TEACH_TO_LOAD_V

772: CURSOR c_cttl(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE,
773: cp_teach_ci_seq_num IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE) IS
774: Select load_cal_type,
775: load_ci_sequence_number
776: FROM IGS_CA_TEACH_TO_LOAD_V
777: WHERE teach_cal_type = cp_teach_cal_type AND
778: teach_ci_sequence_number = cp_teach_ci_seq_num
779: ORDER BY load_start_dt desc ;
780: lv_cttl_rec c_cttl%ROWTYPE;