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_EXTRACT_PKG dependencies on IGS_HE_ST_SPA

Line 13: g_he_st_spa igs_he_st_spa%ROWTYPE;

9: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
10:
11: -- Student / Module related records.
12: g_en_stdnt_ps_att igs_en_stdnt_ps_att%ROWTYPE;
13: g_he_st_spa igs_he_st_spa%ROWTYPE;
14: g_as_su_setatmpt igs_as_su_setatmpt%ROWTYPE;
15: g_he_en_susa igs_he_en_susa%ROWTYPE;
16: g_he_st_prog igs_he_st_prog%ROWTYPE;
17: g_ps_ver igs_ps_ver%ROWTYPE;

Line 1073: igs_he_st_spa_all hspa,

1069: hspa.fe_student_marker ,
1070: enawd.complete_ind,
1071: enawd.conferral_date
1072: FROM igs_en_stdnt_ps_att_all sca,
1073: igs_he_st_spa_all hspa,
1074: igs_he_st_prog_all hprog,
1075: igs_en_spa_awd_aim enawd,
1076: hz_parties pe
1077: WHERE sca.person_id = hspa.person_id

Line 1104: (p_course_cd igs_he_st_spa.course_cd%TYPE,

1100: course_rqrmnts_complete_dt DESC, sca.commencement_dt DESC ;
1101:
1102: -- smaddali modified cursor for bug#3360646, to remove the check for default award
1103: CURSOR c_quaim
1104: (p_course_cd igs_he_st_spa.course_cd%TYPE,
1105: p_version_number igs_he_st_spa.version_number%TYPE)
1106: IS
1107: SELECT award_cd
1108: FROM igs_ps_award

Line 1105: p_version_number igs_he_st_spa.version_number%TYPE)

1101:
1102: -- smaddali modified cursor for bug#3360646, to remove the check for default award
1103: CURSOR c_quaim
1104: (p_course_cd igs_he_st_spa.course_cd%TYPE,
1105: p_version_number igs_he_st_spa.version_number%TYPE)
1106: IS
1107: SELECT award_cd
1108: FROM igs_ps_award
1109: WHERE course_cd = p_course_cd

Line 1116: (p_person_id igs_he_st_spa.person_id%TYPE,

1112:
1113: --smaddali modified where clause for comparing the enrolment dates for bug 2415632
1114: -- smaddali 27-desc-2002 modified cursor to check for conferral date , bug 2702100
1115: CURSOR c_get_yop
1116: (p_person_id igs_he_st_spa.person_id%TYPE,
1117: p_course_cd igs_he_st_spa.course_cd%TYPE,
1118: p_enrl_start_dt DATE,
1119: p_enrl_end_dt DATE,
1120: p_awd_conf_start_dt DATE,

Line 1117: p_course_cd igs_he_st_spa.course_cd%TYPE,

1113: --smaddali modified where clause for comparing the enrolment dates for bug 2415632
1114: -- smaddali 27-desc-2002 modified cursor to check for conferral date , bug 2702100
1115: CURSOR c_get_yop
1116: (p_person_id igs_he_st_spa.person_id%TYPE,
1117: p_course_cd igs_he_st_spa.course_cd%TYPE,
1118: p_enrl_start_dt DATE,
1119: p_enrl_end_dt DATE,
1120: p_awd_conf_start_dt DATE,
1121: p_awd_conf_end_dt DATE)

Line 1176: (p_course_cd igs_he_st_spa.course_cd%TYPE,

1172: ORDER BY susa.rqrmnts_complete_dt DESC, susa.end_dt DESC, susa.selection_dt DESC;
1173:
1174: -- smaddali Modifed cursor to fetch funding_source for hefd208 build , bug#2717751
1175: CURSOR c_get_crse
1176: (p_course_cd igs_he_st_spa.course_cd%TYPE,
1177: p_crv_version_number igs_he_st_spa.version_number%TYPE,
1178: p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
1179: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
1180: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,

Line 1177: p_crv_version_number igs_he_st_spa.version_number%TYPE,

1173:
1174: -- smaddali Modifed cursor to fetch funding_source for hefd208 build , bug#2717751
1175: CURSOR c_get_crse
1176: (p_course_cd igs_he_st_spa.course_cd%TYPE,
1177: p_crv_version_number igs_he_st_spa.version_number%TYPE,
1178: p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
1179: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
1180: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
1181: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,