DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on AP_INVOICES_ALL

Line 1768: FROM ap_invoices_all a,

1764: IF (p_system_reference4 IS NULL OR p_transaction_source = 'AP VARIANCE') THEN
1765:
1766: SELECT nvl(b.exchange_date,a.invoice_date)
1767: INTO l_exchange_date
1768: FROM ap_invoices_all a,
1769: ap_invoice_distributions_all b
1770: WHERE a.invoice_id = p_system_reference2
1771: AND a.invoice_id = b.invoice_id
1772: AND b.distribution_line_number = p_system_reference3;

Line 1782: FROM ap_invoices_all a,

1778: l_inv_pay_id := to_number(p_system_reference4);
1779:
1780: SELECT nvl(b.exchange_date,a.invoice_date)
1781: INTO l_exchange_date
1782: FROM ap_invoices_all a,
1783: ap_invoice_distributions_all b,
1784: ap_invoice_payments c
1785: WHERE c.invoice_payment_id = l_inv_pay_id
1786: AND c.invoice_id = p_system_reference2