APPS.CE_AUTO_BANK_MATCH dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 358: iby_pay_instructions_all B

354: CURSOR LOCK_BATCH_CHECKS (trx_rowid VARCHAR2) IS
355: SELECT c.check_id,
356: b.PAYMENT_INSTRUCTION_ID
357: FROM AP_CHECKS_all C,
358: iby_pay_instructions_all B
359: WHERE c.PAYMENT_INSTRUCTION_ID = b.PAYMENT_INSTRUCTION_ID AND
360: b.rowid = trx_rowid
361: AND nvl(c.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'
362: FOR UPDATE OF c.check_id, b.PAYMENT_INSTRUCTION_ID NOWAIT;

Line 389: iby_pay_instructions_all B,

385: CURSOR LOCK_GROUP_CHECKS (trx_rowid VARCHAR2,X_LOGICAL_GROUP_REFERENCE VARCHAR2) IS
386: SELECT ACA.check_id,
387: b.PAYMENT_INSTRUCTION_ID
388: FROM AP_CHECKS_all ACA,
389: iby_pay_instructions_all B,
390: iby_payments_all IPA
391: WHERE ACA.PAYMENT_INSTRUCTION_ID = b.PAYMENT_INSTRUCTION_ID AND
392: b.rowid = trx_rowid
393: AND nvl(ACA.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'