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_HE_FTE_CALC_PKG dependencies on IGS_CA_INST_ALL

Line 971: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

967: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
968: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
969: cp_lev_dt DATE ) IS
970: SELECT tr.program_version , tr.coo_id
971: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
972: WHERE tr.term_cal_type = ca.cal_type AND
973: tr.term_sequence_number = ca.sequence_number AND
974: tr.person_id = cp_person_id AND
975: tr.program_cd = cp_course_cd AND

Line 985: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

981: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
982: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
983: cp_lev_dt DATE ) IS
984: SELECT tr.program_version , tr.coo_id
985: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
986: WHERE tr.term_cal_type = ca.cal_type AND
987: tr.term_sequence_number = ca.sequence_number AND
988: tr.person_id = cp_person_id AND
989: tr.program_cd = cp_course_cd AND

Line 999: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

995: -- Get the latest term record for the Continuing students
996: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
997: cp_course_cd igs_en_spa_terms.program_cd%TYPE) IS
998: SELECT tr.program_version , tr.coo_id
999: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1000: WHERE tr.term_cal_type = ca.cal_type AND
1001: tr.term_sequence_number = ca.sequence_number AND
1002: tr.person_id = cp_person_id AND
1003: tr.program_cd = cp_course_cd AND