70: WHERE uoo_id = cp_uoo_id;
71:
72: l_host igs_ps_us_exam_meet.host%TYPE;
73:
74: CURSOR c_building(cp_building_id igs_ad_building_all.building_id%TYPE,
75: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
76: SELECT 'X'
77: FROM igs_ad_building_all
78: WHERE building_id = cp_building_id
71:
72: l_host igs_ps_us_exam_meet.host%TYPE;
73:
74: CURSOR c_building(cp_building_id igs_ad_building_all.building_id%TYPE,
75: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
76: SELECT 'X'
77: FROM igs_ad_building_all
78: WHERE building_id = cp_building_id
79: AND location_cd = cp_location_cd
73:
74: CURSOR c_building(cp_building_id igs_ad_building_all.building_id%TYPE,
75: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
76: SELECT 'X'
77: FROM igs_ad_building_all
78: WHERE building_id = cp_building_id
79: AND location_cd = cp_location_cd
80: AND closed_ind = 'N';
81:
78: WHERE building_id = cp_building_id
79: AND location_cd = cp_location_cd
80: AND closed_ind = 'N';
81:
82: CURSOR c_room(cp_room_id igs_ad_room_all.room_id%TYPE,cp_building_id igs_ad_building_all.building_id%TYPE) IS
83: SELECT 'X'
84: FROM igs_ad_room_all
85: WHERE room_id = cp_room_id
86: AND building_id =cp_building_id