[Home] [Help]
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
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
1042: SELECT b.occurrence_identifier,a.unit_cd,a.version_number,a.location_cd,a.unit_class,c.alternate_code
1043: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b, igs_ca_inst_all c
1044: WHERE a.uoo_id=b.uoo_id
1045: AND b.unit_section_occurrence_id=cp_unit_section_occurrence_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
1042: SELECT b.occurrence_identifier,a.unit_cd,a.version_number,a.location_cd,a.unit_class,c.alternate_code
1043: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b, igs_ca_inst_all c
1044: WHERE a.uoo_id=b.uoo_id
1045: AND b.unit_section_occurrence_id=cp_unit_section_occurrence_id
1046: AND a.cal_type=c.cal_type
1047: AND a.ci_sequence_number=c.sequence_number;