APPS.CE_AUTO_BANK_MATCH dependencies on AP_CHECKS_ALL

Line 168: FROM ap_checks_all c,

164: -- Checks
165: --
166: CURSOR lock_200 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
167: SELECT c.check_id
168: FROM ap_checks_all c,
169: ce_statement_reconcils_all rec
170: WHERE c.rowid = trx_rowid
171: AND rec.reference_id(+) = c.check_id
172: AND rec.reference_type(+) = 'PAYMENT'

Line 182: FROM ap_checks_all c

178: -- Check clearing
179: --
180: CURSOR clear_lock_200 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
181: SELECT c.check_id, c.status_lookup_code
182: FROM ap_checks_all c
183: WHERE c.rowid = trx_rowid
184: FOR UPDATE OF c.check_id NOWAIT;
185:
186: --

Line 338: FROM AP_CHECKS_all C,

334: --
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'

Line 348: FROM AP_CHECKS_all C,

344:
345: /* bug 5350073
346: SELECT c.check_id,
347: b.checkrun_id
348: FROM AP_CHECKS_all C,
349: AP_INVOICE_SELECTION_CRITERIA B
350: WHERE c.checkrun_id = b.checkrun_id AND
351: b.rowid = trx_rowid
352: AND nvl(c.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'

Line 369: FROM AP_CHECKS_all ACA,

365: /* for SEPA ER 6700007 begins */
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

Line 388: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

384: WHERE batch_id = X_batch_id
385: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
386: AND application_id = 200
387: AND EXISTS ( SELECT 1
388: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
389: WHERE ACA.CHECK_ID =catv.trx_id
390: AND ACA.PAYMENT_INSTRUCTION_ID = X_batch_id
391: AND IPA.PAYMENT_INSTRUCTION_ID = X_batch_id
392: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID

Line 2206: ap_checks_all c,

2202: --ce_bank_acct_uses_ou_v aba2, -- Bug 9062935 removed use of view
2203: iby_ext_bank_accounts ext, -- Bug 9062935
2204: --ce_bank_accounts ba2, -- Bug 9361270 Commented Line
2205: ap_payment_history_all aph,
2206: ap_checks_all c,
2207: ap_invoice_payments_all pay,
2208: ap_invoices_all inv,
2209: po_vendors ven
2210: WHERE sob.set_of_books_id = sp.set_of_books_id

Line 2488: ap_checks_all c,

2484: ce_statement_reconcils_all rec,
2485: ce_bank_accounts ba,
2486: ce_bank_acct_uses_ou_v aba,
2487: ap_payment_history_all aph,
2488: ap_checks_all c,
2489: ap_invoice_payments_all pay,
2490: ap_invoices_all inv,
2491: po_vendors ven
2492: WHERE sob.set_of_books_id = sp.set_of_books_id

Line 3110: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

3106: AND nvl(catv.status, 'NEGOTIABLE') <> 'VOIDED'
3107: AND catv.application_id = 200
3108: AND NVL(catv.reconciled_status_flag, 'N') = 'N'
3109: AND EXISTS ( SELECT 1
3110: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
3111: WHERE ACA.CHECK_ID =catv.trx_id
3112: AND ACA.PAYMENT_INSTRUCTION_ID = CE_AUTO_BANK_MATCH.trx_id
3113: AND IPA.PAYMENT_INSTRUCTION_ID = CE_AUTO_BANK_MATCH.trx_id
3114: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID