eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYMENT_MANAGER_PKG dependencies on IBY_PAYMENTS_ALL

Line 170: FROM iby_payments_all pmt

166: INTO l_process_count
167: FROM dual
168: WHERE EXISTS
169: (SELECT 'PROCESSING'
170: FROM iby_payments_all pmt
171: WHERE pmt.payment_service_request_id =c_rec_snap.payment_service_request_id
172: AND pmt.payment_status NOT IN('REMOVED', 'VOID', 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW', 'REMOVED_PAYMENT_STOPPED', 'REMOVED_DOCUMENT_SPOILED', 'REMOVED_INSTRUCTION_TERMINATED',
173: 'REMOVED_REQUEST_TERMINATED', 'ISSUED', 'TRANSMITTED', 'REJECTED')
174: AND pmt.payments_complete_flag <> 'Y'

Line 239: FROM iby_payments_all pmt,

235: pmt_all.ORG_ID
236: FROM
237: (SELECT DISTINCT pmt.payment_instruction_id INSTR_ID,
238: pmt.org_id ORG_ID
239: FROM iby_payments_all pmt,
240: iby_pay_instructions_all instr
241: WHERE p_payment_service_request_id = pmt.payment_service_request_id
242: AND instr.payment_instruction_id = pmt.payment_instruction_id
243: AND (instr.payment_instruction_status IN ('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED', 'FORMATTED_READY_FOR_PRINTING',