DBA Data[Home] [Help]

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 607: FROM HZ_CUST_ACCOUNTS cust, HZ_PARTIES part, AP_INVOICES_ALL aia

603: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
604:
605: CURSOR customer_num_cur IS
606: SELECT DISTINCT part.party_number Customer_Number
607: FROM HZ_CUST_ACCOUNTS cust, HZ_PARTIES part, AP_INVOICES_ALL aia
608: WHERE cust.cust_account_id = aia.party_id
609: AND cust.party_id = part.party_id
610: AND aia.Invoice_Id = pn_invoice_id; --parameter: pn_invoice_id
611: