IBY_PAY_INSTRUCTIONS_ALL

SELECT *

FROM   IBY_PAY_INSTRUCTIONS_ALL

WHERE payment_instruction_id IN

       (SELECT payment_instruction_id

        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'

              );

        );