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_POOUS

Line 18: g_he_poous igs_he_poous%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;
18: g_he_poous igs_he_poous%ROWTYPE;
19: g_pe_person igs_pe_person%ROWTYPE;
20: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;
21:
22: g_records_found BOOLEAN := FALSE;

Line 1182: p_unit_set_cd igs_he_poous_all.unit_set_cd%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,
1182: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
1183: p_us_version_number igs_he_poous_all.us_version_number%TYPE)
1184: IS
1185: SELECT crv.title,
1186: crv.std_annual_load,

Line 1183: p_us_version_number igs_he_poous_all.us_version_number%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,
1182: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
1183: p_us_version_number igs_he_poous_all.us_version_number%TYPE)
1184: IS
1185: SELECT crv.title,
1186: crv.std_annual_load,
1187: crv.contact_hours,

Line 1201: igs_he_poous hpud

1197: hpud.fte_intensity ,
1198: hpud.funding_source
1199: FROM igs_ps_ver crv,
1200: igs_he_st_prog hpr,
1201: igs_he_poous hpud
1202: WHERE crv.course_cd = hpr.course_cd
1203: AND crv.version_number = hpr.version_number
1204: AND crv.course_cd = p_course_cd
1205: AND crv.version_number = p_crv_version_number