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_EN_GEN_010 dependencies on IGS_AS_ASSESSMNT_ITM

Line 9865: igs_as_assessmnt_itm ai_dest,

9861: cp_dest_uoo_id NUMBER) IS
9862: SELECT usai_dest.UNIT_SECTION_ASS_ITEM_ID
9863: FROM igs_ps_unitass_item_v usai_source,
9864: igs_ps_unitass_item_v usai_dest,
9865: igs_as_assessmnt_itm ai_dest,
9866: igs_as_assessmnt_itm ai_source
9867: WHERE usai_source.unit_section_ass_item_id = cp_unit_section_ass_item_id
9868: and usai_dest.uoo_id = cp_dest_uoo_id
9869: and usai_dest.ass_id = ai_dest.ass_id

Line 9866: igs_as_assessmnt_itm ai_source

9862: SELECT usai_dest.UNIT_SECTION_ASS_ITEM_ID
9863: FROM igs_ps_unitass_item_v usai_source,
9864: igs_ps_unitass_item_v usai_dest,
9865: igs_as_assessmnt_itm ai_dest,
9866: igs_as_assessmnt_itm ai_source
9867: WHERE usai_source.unit_section_ass_item_id = cp_unit_section_ass_item_id
9868: and usai_dest.uoo_id = cp_dest_uoo_id
9869: and usai_dest.ass_id = ai_dest.ass_id
9870: and usai_source.ass_id = ai_source.ass_id

Line 9883: igs_as_assessmnt_itm ai_dest,

9879: cp_dest_course_cd VARCHAR2,
9880: cp_dest_uoo_id NUMBER) IS
9881: SELECT suv_dest.unit_ass_item_id
9882: FROM igs_as_uai_sua_v suv_dest ,
9883: igs_as_assessmnt_itm ai_dest,
9884: igs_as_uai_sua_v suv_source
9885: WHERE suv_dest.uai_logical_delete_dt is null
9886: and ai_dest.ass_id = suv_dest.ass_id
9887: and suv_dest.person_id = cp_person_id