IBY_PAYMENTS_ALL

SELECT *

FROM   IBY_PAYMENTS_ALL

WHERE payment_id IN

       (SELECT payment_id

        FROM   IBY_DOCS_PAYABLE_ALL

        WHERE   calling_app_id              = 200

        AND     calling_app_doc_unique_ref2 = '166014'

        );