SELECT  PO.OPERATION_ID
FROM    PARTNER_OPERATIONS PO
WHERE   PO.IS_ARCH              = 0
        AND PO.OPER_TYPE        = :B6
        AND PO.REQUEST_CATEGORY = 'Advice'
        AND PO.SKVIT_STATUS     = 2
        AND
        (
                (
                        :B4 IS NULL
                )
                OR
                (
                        (
                                (
                                        (
                                                :B5 = 1
                                        )
                                        AND PO.OPER_DATE <= :B4
                                )
                                OR
                                (
                                        PO.OPER_DATE = :B4
                                )
                        )
                )
        )
        AND
        (
                (
                        PO.RRN IS NULL
                )
                OR
                (
                        PO.RRN = :B3
                )
        )
        AND
        (
                (
                        PO.SRN IS NULL
                )
                OR
                (
                        PO.SRN = :B2
                )
        )
        AND ABS(PO.AMOUNT) = ABS(:B1 )
        AND ROWNUM         = 1

SELECT  OO.OPERATION_ID
FROM    OW4_OPERATIONS OO
WHERE   OO.IS_ARCH              = 0
        AND OO.OPER_TYPE        = :B6
        AND OO.REQUEST_CATEGORY = 'Advice'
        AND OO.SKVIT_STATUS     = 2
        AND
        (
                (
                        :B4 IS NULL
                )
                OR
                (
                        (
                                (
                                        (
                                                :B5 = 1
                                        )
                                        AND OO.LOCAL_DATE <= :B4
                                )
                                OR
                                (
                                        OO.LOCAL_DATE = :B4
                                )
                        )
                )
        )
        AND
        (
                (
                        OO.RRN IS NULL
                )
                OR
                (
                        OO.RRN = :B3
                )
        )
        AND
        (
                (
                        OO.ARN IS NULL
                )
                OR
                (
                        OO.ARN = :B2
                )
        )
        AND ABS(OO.AMOUNT) = ABS(:B1 )
        AND ROWNUM         = 1