APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_EN_SPA_TERMS

Line 889: CURSOR c_term_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,

885:
886: -- smaddali added following cursors for HECR214 - term based fees enhancement build, bug#3291656
887:
888: -- Get the latest Term record for the Leavers,where the student left date lies between term start and end dates
889: CURSOR c_term_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
890: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
891: cp_lev_dt DATE ) IS
892: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
893: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

Line 890: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

886: -- smaddali added following cursors for HECR214 - term based fees enhancement build, bug#3291656
887:
888: -- Get the latest Term record for the Leavers,where the student left date lies between term start and end dates
889: CURSOR c_term_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
890: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
891: cp_lev_dt DATE ) IS
892: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
893: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
894: WHERE tr.term_cal_type = ca.cal_type AND

Line 893: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

889: CURSOR c_term_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
890: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
891: cp_lev_dt DATE ) IS
892: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
893: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
894: WHERE tr.term_cal_type = ca.cal_type AND
895: tr.term_sequence_number = ca.sequence_number AND
896: tr.person_id = cp_person_id AND
897: tr.program_cd = cp_course_cd AND

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

899: ORDER BY ca.start_dt DESC;
900: c_term_lev_rec c_term_lev%ROWTYPE ;
901:
902: -- Get the latest term record for the Continuing students, where the term start date lies in the HESA submission period
903: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
904: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
905: cp_sub_start_dt igs_he_submsn_header.enrolment_start_date%TYPE ,
906: cp_sub_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
907: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type

Line 904: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

900: c_term_lev_rec c_term_lev%ROWTYPE ;
901:
902: -- Get the latest term record for the Continuing students, where the term start date lies in the HESA submission period
903: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
904: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
905: cp_sub_start_dt igs_he_submsn_header.enrolment_start_date%TYPE ,
906: cp_sub_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
907: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
908: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

Line 908: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

904: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
905: cp_sub_start_dt igs_he_submsn_header.enrolment_start_date%TYPE ,
906: cp_sub_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
907: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
908: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
909: WHERE tr.term_cal_type = ca.cal_type AND
910: tr.term_sequence_number = ca.sequence_number AND
911: tr.person_id = cp_person_id AND
912: tr.program_cd = cp_course_cd AND