APPS.AP_IMPORT_VALIDATION_PKG dependencies on HZ_PARTIES

Line 2488: FROM hz_parties hzp

2484: END IF;
2485:
2486: SELECT party_id
2487: INTO l_party_id
2488: FROM hz_parties hzp
2489: WHERE party_id = p_invoice_rec.party_id;
2490:
2491: END IF;
2492:

Line 23864: FROM hz_parties

23860: WHEN NO_DATA_FOUND THEN
23861: BEGIN
23862: SELECT party_name
23863: INTO l_remit_supplier_name
23864: FROM hz_parties
23865: WHERE party_name = p_invoice_rec.remit_to_supplier_name;
23866: EXCEPTION
23867: WHEN NO_DATA_FOUND THEN
23868: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(

Line 24216: FROM hz_parties

24212: EXCEPTION
24213: WHEN NO_DATA_FOUND THEN
24214: SELECT party_id
24215: INTO l_remit_party_id
24216: FROM hz_parties
24217: WHERE party_name = p_invoice_rec.remit_to_supplier_name;
24218: END;
24219: END IF;
24220:

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

24287: END IF;
24288:
24289: -- Bug 7675510
24290: -- Added the invoice_type_lookup_code condition to populate the l_remit_supplier_id,
24291: -- l_remit_supplier_name, l_remit_supplier_num from HZ_PARTIES table in case of PAYMENT REQUEST
24292: -- since the data is not available in AP_SUPPLIERS table for PAYMENT REQUEST type
24293:
24294:
24295: -- commented below IF part as part of bug 8345877.

Line 24311: FROM hz_parties

24307: IF (l_remit_party_id is not null) THEN
24308: --Bug 7860631 Removed the party_id field into the supplier_id field.
24309: SELECT party_name, party_number
24310: INTO l_remit_supplier_name, l_remit_supplier_num
24311: FROM hz_parties
24312: WHERE party_id = l_remit_party_id;
24313: --Bug 7860631 Defaulting the remit_supplier_id from the invoice
24314: l_remit_supplier_id :=p_invoice_rec.vendor_id;
24315: END IF;