6174: FROM igs_ad_building_all
6175: WHERE building_cd = cp_building_cd;
6176:
6177: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
6178: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
6179: SELECT room_id
6180: FROM igs_ad_room_all
6181: WHERE
6182: room_cd = cp_room_cd AND
6176:
6177: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
6178: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
6179: SELECT room_id
6180: FROM igs_ad_room_all
6181: WHERE
6182: room_cd = cp_room_cd AND
6183: building_id = cp_building_id;
6184: