APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_INVOICES_ALL

Line 944: ap_invoices_all ai

940: -- bug 7611160
941: SELECT asp.base_currency_code
942: INTO ap_accounting_pay_pkg.g_base_currency_code
943: FROM ap_system_parameters_all asp,
944: ap_invoices_all ai
945: WHERE asp.org_id = ai.org_id
946: AND ai.invoice_id = l_inv_rec.invoice_id;
947:
948: -- Bug 9492002. Do not do rounding calculations if the invoice being paid

Line 3416: FROM AP_Invoices_All AI,

3412: DECODE(AEL.Accounting_Class_Code, 'LIABILITY' ,AID.Invoice_Distribution_ID, null) APPLIED_TO_DIST_ID_NUM_1,
3413: '-2222' GAIN_OR_LOSS_REF,
3414: APAD.Invoice_Distribution_ID,
3415: APAD.Prepay_Dist_Lookup_Code
3416: FROM AP_Invoices_All AI,
3417: AP_System_Parameters_All ASP,
3418: XLA_Transaction_Entities_upg XTE,
3419: XLA_Events XLE,
3420: AP_Prepay_App_Dists APAD,

Line 3518: FROM AP_Invoices_All AI,

3514: APPLIED_TO_DIST_ID_NUM_1,
3515: '-2222' GAIN_OR_LOSS_REF,
3516: APAD.Invoice_Distribution_ID,
3517: APAD.Prepay_Dist_Lookup_Code
3518: FROM AP_Invoices_All AI,
3519: AP_System_Parameters_All ASP,
3520: XLA_Transaction_Entities_upg XTE,
3521: XLA_Events XLE,
3522: AP_Prepay_App_Dists APAD,