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_EN_SPA_TERMS

Line 967: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,

963: AND sca.course_cd = hspa.course_cd;
964:
965: -- smaddali added cursors for HECR214 - term based fees enhancement build, bug#3291656
966: -- Get the latest Term record for the Leavers during which the student left
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

Line 968: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

964:
965: -- smaddali added cursors for HECR214 - term based fees enhancement build, bug#3291656
966: -- Get the latest Term record for the Leavers during which the student left
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

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 981: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,

977: ORDER BY ca.start_dt DESC;
978: c_term1_lev_rec c_term1_lev%ROWTYPE ;
979:
980: -- Get the latest Term record for the Leavers just before the student left
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

Line 982: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

978: c_term1_lev_rec c_term1_lev%ROWTYPE ;
979:
980: -- Get the latest Term record for the Leavers just before the student left
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

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 996: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,

992: ORDER BY ca.start_dt DESC;
993: c_term2_lev_rec c_term2_lev%ROWTYPE ;
994:
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

Line 997: cp_course_cd igs_en_spa_terms.program_cd%TYPE) IS

993: c_term2_lev_rec c_term2_lev%ROWTYPE ;
994:
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

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