APPS.IGS_PS_GEN_003 dependencies on IGS_PS_USEC_X_GRPMEM

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 1030: FROM igs_ps_usec_x_grpmem

1026:
1027: --check if member of cross listed group
1028: CURSOR chk_crs_list_grp (cp_usec_x_listed_group_id NUMBER) IS
1029: SELECT 'X'
1030: FROM igs_ps_usec_x_grpmem
1031: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id
1032: AND uoo_id = p_n_uoo_id;
1033:
1034: --check if member of meet with group