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_ELGBL_PROGRAM dependencies on IGS_LOOKUPS_VIEW

Line 130: igs_lookups_view lkup

126: eru.notification_flag notification_flag,
127: eru.s_rule_call_cd,
128: eru.rul_sequence_number
129: FROM igs_en_cpd_ext eru,
130: igs_lookups_view lkup
131: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
132: eru.enrolment_cat = p_enrollment_category AND
133: (eru.s_student_comm_type = p_comm_type OR
134: eru.s_student_comm_type = 'ALL' ) AND

Line 146: igs_lookups_view lkup

142: eru.s_rule_call_cd,
143: eru.rul_sequence_number
144: FROM igs_en_cpd_ext eru,
145: igs_pe_usr_aval_all uact,
146: igs_lookups_view lkup
147: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
148: eru.enrolment_cat = p_enrollment_category AND
149: eru.enr_method_type = p_method_type AND
150: (eru.s_student_comm_type = p_comm_type OR

Line 746: igs_lookups_view lkup

742:
743: IF g_system_person_type = 'STUDENT' THEN
744: OPEN cur_program_steps FOR SELECT eru.rul_sequence_number rul_sequence_number
745: FROM igs_en_cpd_ext eru,
746: igs_lookups_view lkup
747: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
748: eru.s_enrolment_step_type = 'UNIT_EXCL' AND
749: eru.enrolment_cat = g_enrollment_category AND
750: (eru.s_student_comm_type = g_comm_type

Line 760: igs_lookups_view lkup

756: ELSE
757: OPEN cur_program_steps FOR SELECT eru.rul_sequence_number rul_sequence_number
758: FROM igs_en_cpd_ext eru,
759: igs_pe_usr_aval_all uact,
760: igs_lookups_view lkup
761: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
762: lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT' AND
763: eru.s_enrolment_step_type = 'UNIT_EXCL' AND
764: eru.enrolment_cat = g_enrollment_category AND