[Home] [Help]
197: where exists(
198: select 'USED'
199: FROM
200: iby_payments_all pmt,
201: iby_pay_instructions_all inst
202: WHERE
203: inst.payment_document_id = p_payment_document_id
204: AND inst.payment_instruction_id = pmt.payment_instruction_id
205: AND pmt.paper_document_number BETWEEN p_from_doc_num and p_to_doc_num);