DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_UTILITIES_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 56: financials_system_parameters fsp

52: CURSOR po_enc_reversed_cur IS
53: SELECT sum(nvl(ael.accounted_cr,0) - nvl(ael.accounted_dr,0))
54: FROM AP_INVOICE_DISTRIBUTIONS aid,
55: AP_ENCUMBRANCE_LINES ael,
56: financials_system_parameters fsp
57: WHERE aid.po_distribution_id = P_po_distribution_id
58: AND aid.invoice_distribution_id = ael.invoice_distribution_id
59: AND ( ( p_start_gl_date is not null
60: and p_start_gl_date <= ael.accounting_date ) or

Line 89: financials_system_parameters fs

85: nvl(aid.exchange_rate_variance,0) -
86: nvl(aid.base_quantity_variance,0))
87: FROM ap_invoice_distributions aid,
88: po_distributions pd,
89: financials_system_parameters fs
90: where aid.po_distribution_id = p_po_distribution_id
91: and aid.po_distribution_id = pd.po_distribution_id
92: and nvl(aid.org_id,-1) = nvl(fs.org_id,-1)
93: and fs.inv_encumbrance_type_id <> fs.purch_encumbrance_type_id