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_IDENTIFY_TARGET_POP dependencies on IGS_HE_SUBMSN_HEADER

Line 722: CURSOR cur_he_sub_header (cp_submission_name igs_he_submsn_header.submission_name%TYPE) IS

718: - Added new european countries to allowed domicile codes for Leaver students
719: *******************************************************************/
720:
721: -- Get the reporting dates for the submission
722: CURSOR cur_he_sub_header (cp_submission_name igs_he_submsn_header.submission_name%TYPE) IS
723: SELECT enrolment_start_date,
724: enrolment_end_date
725: FROM igs_he_submsn_header
726: WHERE submission_name = cp_submission_name ;

Line 725: FROM igs_he_submsn_header

721: -- Get the reporting dates for the submission
722: CURSOR cur_he_sub_header (cp_submission_name igs_he_submsn_header.submission_name%TYPE) IS
723: SELECT enrolment_start_date,
724: enrolment_end_date
725: FROM igs_he_submsn_header
726: WHERE submission_name = cp_submission_name ;
727:
728: l_he_sub_header cur_he_sub_header%ROWTYPE;
729:

Line 743: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

739:
740: -- Get the SUSA details for deriving MODE, LOCSDY and MSTUFEE field values
741: CURSOR c_yop_susa (cp_person_id igs_as_su_setatmpt.person_id%TYPE,
742: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
743: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
744: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
745: SELECT DISTINCT susa.unit_set_cd,
746: susa.us_version_number,
747: susa.sequence_number,

Line 744: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

740: -- Get the SUSA details for deriving MODE, LOCSDY and MSTUFEE field values
741: CURSOR c_yop_susa (cp_person_id igs_as_su_setatmpt.person_id%TYPE,
742: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
743: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
744: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
745: SELECT DISTINCT susa.unit_set_cd,
746: susa.us_version_number,
747: susa.sequence_number,
748: susa.rqrmnts_complete_dt,

Line 905: cp_sub_start_dt igs_he_submsn_header.enrolment_start_date%TYPE ,

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
909: WHERE tr.term_cal_type = ca.cal_type AND

Line 906: cp_sub_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

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
909: WHERE tr.term_cal_type = ca.cal_type AND
910: tr.term_sequence_number = ca.sequence_number AND