SELECT GUBUN
                      , BSNS_ID
                      , CHANNEL_ID
                      , HOTEL_ID
                      , MAX(PROC_KEY_SEQ) PROC_KEY_SEQ
                   FROM (SELECT GUBUN
                              , BSNS_ID
                              , CHANNEL_ID
                              , HOTEL_ID
                              , MAX(PROC_KEY_SEQ) PROC_KEY_SEQ
                           FROM TB_IF_OTA_AVAILRATE_PROC_SEQ
                          WHERE     GUBUN IN (SELECT GUBUN
                                                FROM (SELECT 'AVAIL' GUBUN FROM DUAL
                                                      UNION ALL
                                                      SELECT 'RATE' GUBUN FROM DUAL)
                                               WHERE INSTR(V_IN_GUBUN, GUBUN) > 0)
                                AND BSNS_ID LIKE NVL(TRIM(V_IN_BSNS_ID), '%')
                                AND CHANNEL_ID LIKE NVL(TRIM(V_IN_CHANNEL_ID), '%')
                                AND HOTEL_ID LIKE NVL(TRIM(V_IN_HOTEL_ID), '%')
                                AND PROC_KEY_SEQ <= NVL(V_IN_CUT_PROC_KEY_SEQ, 29991231125959)
                         GROUP BY GUBUN
                                , BSNS_ID
                                , CHANNEL_ID
                                , HOTEL_ID
                         UNION ALL
                         SELECT DISTINCT GUBUN
                                       , BSNS_ID
                                                , CHANNEL_ID
                                       , OTA_HOTEL_CODE
                                       , 19000101010000 PROC_KEY_SEQ
                           FROM VI_CM_CHNL_ROOM_TYPE_DOM, (SELECT GUBUN
                                                             FROM (SELECT 'AVAIL' GUBUN FROM DUAL
                                                                   UNION ALL
                                                                   SELECT 'RATE' GUBUN FROM DUAL)
                                                            WHERE INSTR(V_IN_GUBUN, GUBUN) > 0)
                          WHERE     BSNS_ID LIKE NVL(TRIM(V_IN_BSNS_ID), '%')
                                AND CHANNEL_ID LIKE NVL(TRIM(V_IN_CHANNEL_ID), '%')
                                AND OTA_HOTEL_CODE LIKE NVL(TRIM(V_IN_HOTEL_ID), '%'))
                 GROUP BY GUBUN
                        , BSNS_ID
                        , CHANNEL_ID
                        , HOTEL_ID