DBA Data[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on HZ_PARTIES

Line 1559: FROM ap_suppliers aps, hz_parties hzp, ap_invoices_all ai

1555:
1556: -- Bug 7706967 - Start
1557: SELECT nvl(aps.vendor_name, hzp.party_name)
1558: INTO l_vendor_name
1559: FROM ap_suppliers aps, hz_parties hzp, ap_invoices_all ai
1560: WHERE ai.invoice_id = p_invoice_id
1561: AND aps.vendor_id = ai.vendor_id
1562: AND hzp.party_id = aps.party_id
1563: AND ROWNUM = 1;