DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1769: ap_invoice_distributions_all b

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;
1773:

Line 1783: ap_invoice_distributions_all b,

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
1787: AND c.invoice_id = b.invoice_id