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_ADD_UNITS_API dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 3313: FROM igs_en_su_attempt sua,igs_ca_teach_to_load_v load

3309:
3310: -- cursor to fetch preenroll units
3311: CURSOR c_get_preenr_units IS
3312: SELECT DISTINCT sua.uoo_id, sua.sup_unit_cd, no_assessment_ind,unit_Attempt_Status,ss_source_ind
3313: FROM igs_en_su_attempt sua,igs_ca_teach_to_load_v load
3314: WHERE sua.person_id = p_person_id
3315: AND sua.course_cd = p_course_cd
3316: AND sua.unit_attempt_status = 'UNCONFIRM'
3317: AND NVL(sua.ss_source_ind ,'N') <> 'S'

Line 4378: FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v lod

4374:
4375: -- cursor to fetch the swap units
4376: CURSOR cur_swap_units IS
4377: SELECT DISTINCT sua.uoo_id, sua.sup_unit_cd, sua.no_assessment_ind
4378: FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v lod
4379: WHERE sua.person_id = p_person_Id
4380: AND sua.course_cd = p_course_cd
4381: AND sua.unit_attempt_status = 'UNCONFIRM'
4382: AND lod.teach_cal_type = sua.cal_type

Line 4392: FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v lod

4388:
4389: -- cursor to get the cart units
4390: CURSOR cur_cart_units IS
4391: SELECT DISTINCT sua.uoo_id, sua.sup_unit_cd
4392: FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v lod
4393: WHERE sua.person_id = p_person_Id
4394: AND sua.course_cd = p_course_cd
4395: AND sua.unit_attempt_status = 'UNCONFIRM'
4396: AND sua.SS_SOURCE_IND <> 'S'