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_FIELDS_PKG dependencies on IGS_HE_ST_UNT_VS_ALL

Line 4072: igs_he_st_unt_vs_all hunt

4068: FROM igs_en_su_attempt a,
4069: igs_ps_tch_resp b,
4070: igs_pe_hz_parties ihpou,
4071: igs_pe_hz_parties ihpinst,
4072: igs_he_st_unt_vs_all hunt
4073: WHERE a.course_cd = p_course_cd
4074: AND a.person_id = p_person_id
4075: AND b.unit_cd = a.unit_cd
4076: AND b.version_number = a.version_number

Line 4186: igs_he_st_unt_vs_all hunt

4182: igs_pe_hz_parties ihpou,
4183: igs_pe_hz_parties ihpinst,
4184: igs_ps_unit_ver e,
4185: igs_ps_usec_cps cps,
4186: igs_he_st_unt_vs_all hunt
4187: WHERE a.course_cd = p_course_cd
4188: AND a.person_id = p_person_id
4189: AND b.unit_cd = a.unit_cd
4190: AND b.version_number = a.version_number

Line 4208: igs_he_st_unt_vs_all hunt

4204: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,e.enrolled_credit_points))) Total_credit_points
4205: FROM igs_en_su_attempt a,
4206: igs_ps_unit_ver e,
4207: igs_ps_usec_cps cps,
4208: igs_he_st_unt_vs_all hunt
4209: WHERE a.course_cd = p_course_cd
4210: AND a.person_id = p_person_id
4211: AND a.unit_cd = hunt.unit_cd (+)
4212: AND a.version_number = hunt.version_number (+)

Line 4401: igs_he_st_unt_vs_all hunt

4397: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,b.enrolled_credit_points)) ) credit_points, b.unit_level
4398: FROM igs_en_su_attempt a ,
4399: igs_ps_unit_ver b,
4400: igs_ps_usec_cps cps,
4401: igs_he_st_unt_vs_all hunt
4402: WHERE a.course_cd = p_course_cd
4403: AND a.person_id = p_person_id
4404: AND a.unit_cd = b.unit_cd
4405: AND a.version_number = b.version_number

Line 4653: igs_he_st_unt_vs_all hunt

4649: SELECT 'X'
4650: FROM igs_he_unt_ou_cc a,
4651: igs_en_su_attempt_all b,
4652: igs_ps_tch_resp c,
4653: igs_he_st_unt_vs_all hunt
4654: WHERE b.course_cd = p_course_cd
4655: AND b.person_id = p_person_id
4656: AND a.unit_cd = b.unit_cd
4657: AND a.version_number = b.version_number

Line 4882: igs_he_st_unt_vs_all hunt

4878: SUM(proportion*percentage/100) proportion
4879: FROM igs_he_unt_ou_cc a,
4880: igs_en_su_attempt_all b,
4881: igs_ps_tch_resp c,
4882: igs_he_st_unt_vs_all hunt
4883: WHERE b.course_cd = p_course_cd
4884: AND b.person_id = p_person_id
4885: AND a.unit_cd = b.unit_cd
4886: AND a.version_number = b.version_number

Line 6135: igs_he_st_unt_vs_all d,

6131: NVL(cps.enrolled_credit_points,b.enrolled_credit_points) enrolled_credit_point
6132: FROM igs_en_su_attempt_all a,
6133: igs_ps_unit_ver_all b,
6134: igs_he_st_spa_all c,
6135: igs_he_st_unt_vs_all d,
6136: igs_ps_usec_cps cps
6137: WHERE a.unit_cd = b.unit_cd
6138: AND a.version_number = b.version_number
6139: AND c.person_id = a.person_id

Line 6157: igs_he_st_unt_vs_all d,

6153: NVL(cps.enrolled_credit_points,b.enrolled_credit_points) enrolled_credit_point
6154: FROM igs_en_su_attempt_all a,
6155: igs_ps_unit_ver_all b,
6156: igs_he_st_spa_all c,
6157: igs_he_st_unt_vs_all d,
6158: igs_as_su_stmptout e,
6159: igs_ps_usec_cps cps
6160: WHERE a.unit_cd = b.unit_cd
6161: AND a.version_number = b.version_number