APPS.AP_ACCOUNTING_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 54: FROM AP_INVOICE_DISTRIBUTIONS aid,

50: l_total_unencumbered_amount NUMBER;
51:
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

Line 87: FROM ap_invoice_distributions aid,

83: SELECT sum (nvl(nvl(aid.base_amount,aid.amount),0) -
84: nvl(aid.base_invoice_price_variance ,0) -
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