APPS.IGS_SS_ENR_DETAILS dependencies on IGS_AD_ROOM_ALL

Line 3288: FROM igs_ad_room_all

3284: -- Internal function to get the room code for the given room identifier
3285: FUNCTION get_room_code(p_n_room_id IN NUMBER) RETURN VARCHAR2 IS
3286: CURSOR c_room_code (cp_n_room_id IN NUMBER) IS
3287: SELECT room_cd
3288: FROM igs_ad_room_all
3289: WHERE room_id = cp_n_room_id;
3290: l_c_room_cd igs_ad_room_all.room_cd%TYPE;
3291: BEGIN
3292: OPEN c_room_code (p_n_room_id );

Line 3290: l_c_room_cd igs_ad_room_all.room_cd%TYPE;

3286: CURSOR c_room_code (cp_n_room_id IN NUMBER) IS
3287: SELECT room_cd
3288: FROM igs_ad_room_all
3289: WHERE room_id = cp_n_room_id;
3290: l_c_room_cd igs_ad_room_all.room_cd%TYPE;
3291: BEGIN
3292: OPEN c_room_code (p_n_room_id );
3293: FETCH c_room_code INTO l_c_room_cd;
3294: CLOSE c_room_code;