WITH
    T AS
    (
        SELECT 1 seq, '2012/09/07 13:31:01' beg_dt, '2012/09/07 14:16:01' end_dt FROM dual Union all
        SELECT 2 seq, '2012/09/07 20:05:01' beg_dt, '2012/09/07 20:05:01' end_dt FROM dual Union all
        SELECT 3 seq, '2012/09/07 23:20:01' beg_dt, '2012/09/08 00:05:01' end_dt FROM dual Union all
        SELECT 4 seq, '2012/09/07 15:07:01' beg_dt, '2012/09/07 15:52:01' end_dt FROM dual Union all
        SELECT 5 seq, '2012/09/07 16:45:01' beg_dt, '2012/09/07 17:30:01' end_dt FROM dual Union all
        SELECT 6 seq, '2012/09/07 20:26:01' beg_dt, '2012/09/07 21:11:01' end_dt FROM dual Union all
        SELECT 7 seq, '2012/09/08 01:24:01' beg_dt, '2012/09/08 01:24:01' end_dt FROM dual Union all
        SELECT 8 seq, '2012/09/07 09:14:01' beg_dt, '2012/09/07 09:59:01' end_dt FROM dual Union all
        SELECT 9 seq, '2012/09/07 20:35:01' beg_dt, '2012/09/07 21:20:01' end_dt FROM dual Union all
        SELECT 10 seq, '2012/09/07 21:29:01' beg_dt, '2012/09/07 22:14:01' end_dt FROM dual
    )
SELECT  t.*
FROM    T
    ,   T   BASE_T                                                  
WHERE   1=1
AND     BASE_T.seq      = :InSeq                                      
AND     BASE_T.seq      <> T.seq                                 
AND     T.beg_dt        <= BASE_T.end_dt                    
AND     T.end_dt        >= BASE_T.beg_dt