APPS.CE_AUTO_BANK_MATCH dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 339: iby_pay_instructions_all B

335: CURSOR LOCK_BATCH_CHECKS (trx_rowid VARCHAR2) IS
336: SELECT c.check_id,
337: b.PAYMENT_INSTRUCTION_ID
338: FROM AP_CHECKS_all C,
339: iby_pay_instructions_all B
340: WHERE c.PAYMENT_INSTRUCTION_ID = b.PAYMENT_INSTRUCTION_ID AND
341: b.rowid = trx_rowid
342: AND nvl(c.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'
343: FOR UPDATE OF c.check_id, b.PAYMENT_INSTRUCTION_ID NOWAIT;

Line 370: iby_pay_instructions_all B,

366: CURSOR LOCK_GROUP_CHECKS (trx_rowid VARCHAR2,X_LOGICAL_GROUP_REFERENCE VARCHAR2) IS
367: SELECT ACA.check_id,
368: b.PAYMENT_INSTRUCTION_ID
369: FROM AP_CHECKS_all ACA,
370: iby_pay_instructions_all B,
371: iby_payments_all IPA
372: WHERE ACA.PAYMENT_INSTRUCTION_ID = b.PAYMENT_INSTRUCTION_ID AND
373: b.rowid = trx_rowid
374: AND nvl(ACA.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'