APPS.CE_AUTO_BANK_MATCH dependencies on AP_PAYMENT_HISTORY

Line 2205: ap_payment_history_all aph,

2201: ce_bank_accounts ba,
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

Line 2249: from ap_payment_history_all aph2

2245: AND aph.org_id (+) = c.org_id
2246: AND aph.transaction_type (+) = 'PAYMENT CLEARING'
2247: AND not exists
2248: (select null
2249: from ap_payment_history_all aph2
2250: where aph2.check_id = c.check_id
2251: and aph2.org_id = c.org_id
2252: and aph2.transaction_type = 'PAYMENT CLEARING'
2253: and aph2.payment_history_id > aph.payment_history_id);

Line 2487: ap_payment_history_all aph,

2483: ce_system_parameters sp,
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

Line 2529: from ap_payment_history aph2

2525: AND aph.org_id (+) = c.org_id
2526: AND aph.transaction_type (+) = 'PAYMENT CLEARING'
2527: AND not exists
2528: (select null
2529: from ap_payment_history aph2
2530: where aph2.check_id = c.check_id
2531: and aph2.org_id = c.org_id
2532: and aph2.transaction_type = 'PAYMENT CLEARING'
2533: and aph2.payment_history_id > aph.payment_history_id);

Line 3779: from ap_payment_history

3775: if ( CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'PAYMENT' )
3776: then
3777: select max(accounting_date)
3778: into l_unclearing_gl_date
3779: from ap_payment_history
3780: where check_id = CE_AUTO_BANK_MATCH.trx_id
3781: and transaction_type = 'PAYMENT UNCLEARING';
3782:
3783: elsif ( CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')