DBA Data[Home] [Help]

APPS.FV_ECON_BENF_DISC dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 83: FROM ap_system_parameters_all aspa,

79: -- joined with ap_invoice_all to get ledger_id and org_id
80: -- Bug 5470357
81: SELECT nvl(aspa.interest_tolerance_amount,0)
82: INTO P_interest_tolerance_amount
83: FROM ap_system_parameters_all aspa,
84: ap_invoices_all aia
85: WHERE aia.invoice_id = x_invoice_id
86: AND aia.set_of_books_id = aspa.set_of_books_id
87: AND aia.org_id = nvl(aspa.org_id, aia.org_id)