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_EXTRACT2_PKG dependencies on IGS_EN_SPA_TERMS

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

9787:
9788: -- smaddali added following cursors for HECR214 - term based fees enhancement build, bug#3291656
9789:
9790: -- Get the latest Term record for the Leavers,where the student left date lies between term start and end dates
9791: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
9792: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9793: cp_lev_dt DATE ) IS
9794: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9795: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

Line 9792: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

9788: -- smaddali added following cursors for HECR214 - term based fees enhancement build, bug#3291656
9789:
9790: -- Get the latest Term record for the Leavers,where the student left date lies between term start and end dates
9791: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
9792: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9793: cp_lev_dt DATE ) IS
9794: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9795: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9796: WHERE tr.term_cal_type = ca.cal_type AND

Line 9795: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

9791: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
9792: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9793: cp_lev_dt DATE ) IS
9794: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9795: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9796: WHERE tr.term_cal_type = ca.cal_type AND
9797: tr.term_sequence_number = ca.sequence_number AND
9798: tr.person_id = cp_person_id AND
9799: tr.program_cd = cp_course_cd AND

Line 9805: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,

9801: ORDER BY ca.start_dt DESC;
9802: c_term1_lev_rec c_term1_lev%ROWTYPE ;
9803:
9804: -- Get the latest Term record for the Leavers just before the student left
9805: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
9806: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9807: cp_lev_dt DATE,
9808: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9809: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS

Line 9806: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

9802: c_term1_lev_rec c_term1_lev%ROWTYPE ;
9803:
9804: -- Get the latest Term record for the Leavers just before the student left
9805: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
9806: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9807: cp_lev_dt DATE,
9808: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9809: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9810: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type , tr.fee_cat

Line 9811: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

9807: cp_lev_dt DATE,
9808: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9809: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9810: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type , tr.fee_cat
9811: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9812: WHERE tr.term_cal_type = ca.cal_type AND
9813: tr.term_sequence_number = ca.sequence_number AND
9814: tr.person_id = cp_person_id AND
9815: tr.program_cd = cp_course_cd AND

Line 9822: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,

9818: ORDER BY ca.start_dt DESC;
9819: c_term2_lev_rec c_term2_lev%ROWTYPE ;
9820:
9821: -- Get the latest term record for the Continuing students, where the term start date lies in the HESA submission period
9822: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
9823: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9824: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9825: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9826: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat

Line 9823: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

9819: c_term2_lev_rec c_term2_lev%ROWTYPE ;
9820:
9821: -- Get the latest term record for the Continuing students, where the term start date lies in the HESA submission period
9822: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
9823: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9824: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9825: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9826: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9827: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

Line 9827: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

9823: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9824: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9825: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9826: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9827: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9828: WHERE tr.term_cal_type = ca.cal_type AND
9829: tr.term_sequence_number = ca.sequence_number AND
9830: tr.person_id = cp_person_id AND
9831: tr.program_cd = cp_course_cd AND