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_ADI_UPLD_AIO_PKG dependencies on IGS_AS_GEN_003

Line 142: AND igs_as_gen_003.assp_get_ai_ref (suaai.unit_section_ass_item_id, suaai.unit_ass_item_id) = cp_reference

138: WHERE suaai.person_id = cp_person_id
139: AND suaai.course_cd = cp_course_cd
140: AND suaai.uoo_id = cp_uoo_id
141: AND suaai.ass_id = cp_ass_id
142: AND igs_as_gen_003.assp_get_ai_ref (suaai.unit_section_ass_item_id, suaai.unit_ass_item_id) = cp_reference
143: AND suaai.logical_delete_dt IS NULL;
144: --
145: rec_suaai cur_suaai%ROWTYPE;
146: --

Line 718: AND igs_as_gen_003.assp_get_ai_ref (sai.unit_section_ass_item_id, sai.unit_ass_item_id) = cp_reference

714: WHERE sai.person_id = cp_person_id
715: AND sai.course_cd = p_course_cd
716: AND sai.uoo_id = cp_uoo_id
717: AND sai.ass_id = cp_ass_id
718: AND igs_as_gen_003.assp_get_ai_ref (sai.unit_section_ass_item_id, sai.unit_ass_item_id) = cp_reference
719: AND sai.logical_delete_dt IS NULL;
720: --
721: --
722: --

Line 735: AND igs_as_gen_003.assp_get_ai_ref (sai.unit_section_ass_item_id, sai.unit_ass_item_id) = cp_reference

731: WHERE sai.person_id = cp_person_id
732: AND sai.course_cd = p_course_cd
733: AND sai.uoo_id = cp_uoo_id
734: AND sai.ass_id = cp_ass_id
735: AND igs_as_gen_003.assp_get_ai_ref (sai.unit_section_ass_item_id, sai.unit_ass_item_id) = cp_reference
736: AND sai.logical_delete_dt IS NULL;
737: --
738: --
739: --