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_AS_DERIVE_GRADE dependencies on IGS_AS_SU_ATMPT_ITM

Line 147: FROM igs_as_su_atmpt_itm

143: cp_uoo_id IN NUMBER
144: ) IS
145: SELECT DISTINCT grading_schema_cd,
146: gs_version_number
147: FROM igs_as_su_atmpt_itm
148: WHERE person_id = cp_person_id
149: AND course_cd = cp_course_cd
150: AND uoo_id = cp_uoo_id
151: AND logical_delete_dt IS NULL

Line 166: FROM igs_as_su_atmpt_itm suai

162: ) IS
163: SELECT suai.ass_id ass_id,
164: suai.unit_ass_item_id,
165: suai.unit_section_ass_item_id
166: FROM igs_as_su_atmpt_itm suai
167: WHERE suai.person_id = cp_person_id
168: AND suai.course_cd = cp_course_cd
169: AND suai.uoo_id = cp_uoo_id
170: AND suai.grading_schema_cd = cp_grading_schema_cd

Line 352: igs_as_su_atmpt_itm suai,

348: suai.mark,
349: (suai.mark - gslu.lower_limit) *
350: (100 / (gslu.upper_limit - gslu.lower_limit)) common_base_mark
351: FROM igs_as_sua_ai_group suag,
352: igs_as_su_atmpt_itm suai,
353: (SELECT grading_schema_cd,
354: version_number,
355: MIN (lower_mark_range) lower_limit,
356: MAX (upper_mark_range) upper_limit