APPS.CE_AUTO_BANK_MATCH dependencies on AP_CHECKS_ALL

Line 187: FROM ap_checks_all c,

183: -- Checks
184: --
185: CURSOR lock_200 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
186: SELECT c.check_id
187: FROM ap_checks_all c,
188: ce_statement_reconcils_all rec
189: WHERE c.rowid = trx_rowid
190: AND rec.reference_id(+) = c.check_id
191: AND rec.reference_type(+) = 'PAYMENT'

Line 201: FROM ap_checks_all c

197: -- Check clearing
198: --
199: CURSOR clear_lock_200 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
200: SELECT c.check_id, c.status_lookup_code
201: FROM ap_checks_all c
202: WHERE c.rowid = trx_rowid
203: FOR UPDATE OF c.check_id NOWAIT;
204:
205: --

Line 357: FROM AP_CHECKS_all C,

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

Line 367: FROM AP_CHECKS_all C,

363:
364: /* bug 5350073
365: SELECT c.check_id,
366: b.checkrun_id
367: FROM AP_CHECKS_all C,
368: AP_INVOICE_SELECTION_CRITERIA B
369: WHERE c.checkrun_id = b.checkrun_id AND
370: b.rowid = trx_rowid
371: AND nvl(c.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'

Line 388: FROM AP_CHECKS_all ACA,

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

Line 407: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

403: WHERE batch_id = X_batch_id
404: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
405: AND application_id = 200
406: AND EXISTS ( SELECT 1
407: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
408: WHERE ACA.CHECK_ID =catv.trx_id
409: AND ACA.PAYMENT_INSTRUCTION_ID = X_batch_id
410: AND IPA.PAYMENT_INSTRUCTION_ID = X_batch_id
411: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID

Line 2200: ap_checks_all c,

2196: ce_bank_accounts ba,
2197: ce_bank_acct_uses_ou_v aba2,
2198: ce_bank_accounts ba2,
2199: ap_payment_history_all aph,
2200: ap_checks_all c,
2201: ap_invoice_payments_all pay,
2202: ap_invoices_all inv,
2203: po_vendors ven
2204: WHERE sob.set_of_books_id = sp.set_of_books_id

Line 2495: ap_checks_all c,

2491: ce_statement_reconcils_all rec,
2492: ce_bank_accounts ba,
2493: ce_bank_acct_uses_ou_v aba,
2494: ap_payment_history_all aph,
2495: ap_checks_all c,
2496: ap_invoice_payments_all pay,
2497: ap_invoices_all inv,
2498: po_vendors ven
2499: WHERE sob.set_of_books_id = sp.set_of_books_id

Line 3044: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

3040: AND nvl(catv.status, 'NEGOTIABLE') <> 'VOIDED'
3041: AND catv.application_id = 200
3042: AND NVL(catv.reconciled_status_flag, 'N') = 'N'
3043: AND EXISTS ( SELECT 1
3044: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
3045: WHERE ACA.CHECK_ID =catv.trx_id
3046: AND ACA.PAYMENT_INSTRUCTION_ID = CE_AUTO_BANK_MATCH.trx_id
3047: AND IPA.PAYMENT_INSTRUCTION_ID = CE_AUTO_BANK_MATCH.trx_id
3048: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID

Line 6115: ap_checks_all ac,

6111: cursor count_dup_invoice is
6112: select count(*)
6113: from ap_invoices ap,
6114: ap_invoice_payments aip,
6115: ap_checks_all ac,
6116: ce_bank_accounts ba,
6117: ce_bank_acct_uses_ou_v bau
6118: where ba.bank_account_num = CE_AUTO_BANK_MATCH.csl_bank_account_text
6119: and ba.bank_account_id = bau.bank_account_id