APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_AD_ROOM_ALL

Line 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

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

Line 84: FROM igs_ad_room_all

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
87: AND closed_ind = 'N';
88: l_c_var VARCHAR2(1);