APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on PO_VENDORS

Line 393: FROM po_vendors

389: l_contact_rec get_contact_info%ROWTYPE;
390: --
391: CURSOR get_supplier_name (p_vendor_id NUMBER) IS
392: SELECT vendor_name
393: FROM po_vendors
394: WHERE vendor_id = p_vendor_id;
395: --
396: l_supplier_name varchar2(360);
397: l_return_status VARCHAR2(2);

Line 1515: FROM po_vendors

1511: --
1512: CURSOR check_vendor_active (p_vendor_id NUMBER) IS
1513: SELECT end_date_active,
1514: vendor_name
1515: FROM po_vendors
1516: WHERE vendor_id = p_vendor_id;
1517: --
1518: l_end_date_active DATE;
1519: l_supplier_name VARCHAR2(360);

Line 2738: -- Bug 4658824 : Use po_vendors, so we are isolated from any changes

2734: --
2735: l_fromPartyId NUMBER;
2736: l_toPartyId NUMBER;
2737: --
2738: -- Bug 4658824 : Use po_vendors, so we are isolated from any changes
2739: -- that AP makes to their data model
2740: CURSOR c_getParty(p_vendorId IN NUMBER) IS
2741: SELECT party_id
2742: FROM po_vendors

Line 2742: FROM po_vendors

2738: -- Bug 4658824 : Use po_vendors, so we are isolated from any changes
2739: -- that AP makes to their data model
2740: CURSOR c_getParty(p_vendorId IN NUMBER) IS
2741: SELECT party_id
2742: FROM po_vendors
2743: WHERE vendor_id = p_vendorId;
2744: --
2745: BEGIN
2746: --{