APPS.AP_ACCTG_PAY_ROUND_PKG dependencies on AP_CHECKS_ALL

Line 3196: -- ap_checks_all.base_amount and

3192:
3193: -------------------------------------------------------------------------------
3194: -- Final_Cash
3195: -- This is procedure is to handle cash rounding where the
3196: -- ap_checks_all.base_amount and
3197: -- sum(ap_invoice_payments_all.payment_base_amount) are not
3198: -- Matching.
3199: -- Bug 8288996
3200: --

Line 3252: FROM ap_checks_all ac,

3248: decode(aps.recon_accounting_flag, 'Y', 'CLEARING',
3249: decode(ac.future_pay_due_date, NULL, 'CREATED', 'MATURITY')) type,
3250: ac.amount
3251: INTO l_ac_base_amount, l_transaction_type, l_ac_amount
3252: FROM ap_checks_all ac,
3253: ap_system_parameters_all aps,
3254: ap_invoice_payments_all aip
3255: WHERE ac.org_id = aps.org_id
3256: AND ac.check_id = P_XLA_Event_Rec.source_id_int_1