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_PS_GEN_003 dependencies on IGS_PS_USO_CLAS_MEET

Line 986: FROM igs_ps_usec_occurs uso, igs_ps_usec_x_grpmem crs, igs_ps_uso_clas_meet mwg

982:
983:
984: CURSOR chk IS
985: SELECT uso.unit_section_occurrence_id, uso.uoo_id, crs.usec_x_listed_group_id, mwg.class_meet_group_id
986: FROM igs_ps_usec_occurs uso, igs_ps_usec_x_grpmem crs, igs_ps_uso_clas_meet mwg
987: WHERE uso.building_code = p_c_building_cd AND
988: uso.room_code = p_c_room_cd AND
989: (
990: TRUNC( uso.start_date ) BETWEEN TRUNC(p_d_start_date) AND TRUNC(p_d_end_date) OR

Line 1037: FROM igs_ps_uso_clas_meet

1033:
1034: --check if member of meet with group
1035: CURSOR chk_meet_with_grp (cp_class_meet_group_id NUMBER) IS
1036: SELECT 'X'
1037: FROM igs_ps_uso_clas_meet
1038: WHERE class_meet_group_id = cp_class_meet_group_id
1039: AND uoo_id = p_n_uoo_id;
1040:
1041: CURSOR c_occur(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS