APPS.AP_IMPORT_VALIDATION_PKG dependencies on HZ_PARTIES

Line 2358: FROM hz_parties hzp

2354: END IF;
2355:
2356: SELECT party_id
2357: INTO l_party_id
2358: FROM hz_parties hzp
2359: WHERE party_id = p_invoice_rec.party_id;
2360:
2361: END IF;
2362:

Line 22254: -- l_remit_supplier_name, l_remit_supplier_num from HZ_PARTIES table in case of PAYMENT REQUEST

22250: END IF;
22251:
22252: -- Bug 7675510
22253: -- Added the invoice_type_lookup_code condition to populate the l_remit_supplier_id,
22254: -- l_remit_supplier_name, l_remit_supplier_num from HZ_PARTIES table in case of PAYMENT REQUEST
22255: -- since the data is not available in AP_SUPPLIERS table for PAYMENT REQUEST type
22256:
22257: -------------------------------------------------------------------
22258: debug_info := 'Invoice Type Lookup Code '||p_invoice_rec.invoice_type_lookup_code;

Line 22271: FROM hz_parties

22267: IF (l_remit_party_id is not null) THEN
22268: --Bug 7860631 Removed the party_id field into the supplier_id field.
22269: SELECT party_name, party_number
22270: INTO l_remit_supplier_name, l_remit_supplier_num
22271: FROM hz_parties
22272: WHERE party_id = l_remit_party_id;
22273: --Bug 7860631 Defaulting the remit_supplier_id from the invoice
22274: l_remit_supplier_id :=p_invoice_rec.vendor_id;
22275: END IF;