515: ,hzp.party_number third_party_account_number
516: ';
517:
518: C_PARTY_SUPP_TABLE CONSTANT VARCHAR2(32000) := '
519: ,ap_suppliers aps
520: ,ap_supplier_sites_all apss
521: ,hz_parties hzp
522: ,hz_party_sites hps
523: ';
1554: END IF;
1555:
1556: SELECT vendor_name
1557: INTO p_third_party_name
1558: FROM ap_suppliers
1559: WHERE vendor_id = l_party_id;
1560:
1561: END IF;
1562: