APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_INVOICES_ALL

Line 132: AP_Invoices_All AI

128:
129: SELECT ASP.Base_Currency_Code
130: INTO g_base_currency_code
131: FROM AP_System_Parameters_All ASP,
132: AP_Invoices_All AI
133: WHERE AI.Invoice_ID = l_xla_event_rec.source_id_int_1
134: AND AI.Org_ID = ASP.Org_ID;
135:
136: END IF;

Line 1587: ap_invoices_all ai,

1583:
1584: CURSOR Aprvd_UnPrtd_His_Inv IS
1585: SELECT ai.invoice_id
1586: FROM ap_invoice_distributions_all aid,
1587: ap_invoices_all ai,
1588: xla_events_gt xe,
1589: xla_events xle,
1590: financials_system_params_all fsp
1591: WHERE xe.event_type_code IN('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')

Line 1651: l_invoice_id AP_INVOICES_ALL.Invoice_ID%TYPE;

1647: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1648: l_procedure_name CONSTANT VARCHAR2(30) := 'Prorate_Historical_Dists';
1649: --bug12686836
1650: l_prepay_dist_tab NUM_TAB;
1651: l_invoice_id AP_INVOICES_ALL.Invoice_ID%TYPE;
1652: l_rowcount NUMBER;
1653: l_debug_info LONG;
1654: l_curr_calling_sequence VARCHAR2(2000);
1655:

Line 1843: ap_invoices_all ai --added for bug13334090

1839: UNION
1840: -- prepay application
1841: SELECT 'unreversed, unvalidated prepayment application yet to be validated'
1842: FROM ap_invoice_distributions_all aid,
1843: ap_invoices_all ai --added for bug13334090
1844: WHERE aid.invoice_id = p_inv_rec.invoice_id
1845: --AND nvl(aid.match_status_flag, 'N') = 'N' -- commented for bug13334090
1846: AND aid.invoice_id = ai.invoice_id
1847: AND AP_INVOICES_UTILITY_PKG.get_approval_status(ai.invoice_id,