DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 849: from iby_payments_all pmt, iby_pay_instructions_all instr

845: iby.payment_service_request_status = 'PAYMENTS_CREATED'
846: AND EXISTS
847: (
848: select 'NEED_ACTION_BY_ME'
849: from iby_payments_all pmt, iby_pay_instructions_all instr
850: where iby.payment_service_request_id = pmt.payment_service_request_id
851: and instr.payment_instruction_id = pmt.payment_instruction_id
852: and instr.payment_instruction_status IN ('CREATION_ERROR',
853: 'FORMATTED_READY_TO_TRANSMIT',

Line 912: FROM iby_pay_instructions_all inst

908: 'REMOVED_DOCUMENT_SPOILED', 'REMOVED_INSTRUCTION_TERMINATED', 'REMOVED_REQUEST_TERMINATED', 'ISSUED', 'TRANSMITTED', 'REJECTED')
909: AND pmt.payments_complete_flag <> 'Y'
910: AND NOT EXISTS
911: (SELECT 'NEED_ACTION'
912: FROM iby_pay_instructions_all inst
913: WHERE pmt.payment_instruction_id = inst.payment_instruction_id
914: AND inst.payment_instruction_status IN('CREATION_ERROR',
915: 'FORMATTED_READY_TO_TRANSMIT',
916: 'TRANSMISSION_FAILED',