APPS.WSH_SUPPLIER_PARTY dependencies on PO_VENDORS

Line 313: FROM po_vendors pv

309: x_party_id OUT NOCOPY NUMBER) RETURN VARCHAR2 -- Y for Yes, N for No
310: IS
311: CURSOR get_vendor_name IS
312: SELECT pv.vendor_name
313: FROM po_vendors pv
314: WHERE pv.vendor_id = p_vendor_id;
315:
316: l_vendor_name varchar2(400);
317:

Line 334: FROM PO_VENDORS

330:
331: --IB-Phase-2 {
332:
333: SELECT PARTY_ID INTO x_party_id
334: FROM PO_VENDORS
335: WHERE VENDOR_ID = p_vendor_id;
336:
337: --
338:

Line 412: FROM po_vendors pv

408: IS
409:
410: CURSOR get_vendor_name IS
411: SELECT pv.vendor_name
412: FROM po_vendors pv
413: WHERE pv.vendor_id = p_vendor_id;
414:
415: --Cursor to check if code assignment is already exist for party.
416: CURSOR get_code_assignments(p_party_id NUMBER) IS

Line 525: l_party_rel_rec.object_table_name := 'PO_VENDORS';

521: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';
522: l_party_rel_rec.subject_type := 'ORGANIZATION';
523:
524: l_party_rel_rec.object_id := p_vendor_id;
525: l_party_rel_rec.object_table_name := 'PO_VENDORS';
526: l_party_rel_rec.object_type := 'POS_VENDOR';
527:
528: l_party_rel_rec.relationship_code := 'PARTY_OF_VENDOR';
529: l_party_rel_rec.relationship_type := 'POS_VENDOR_PARTY';

Line 1146: FROM po_vendors

1142:
1143:
1144: CURSOR validate_vendor_csr(p_vendor_name varchar2) IS
1145: SELECT vendor_id
1146: FROM po_vendors
1147: WHERE vendor_name =ltrim(rtrim(p_vendor_name))
1148: AND (end_date_active IS NULL OR end_date_active >= SYSDATE); -- IB-phase-2 vendor merge
1149:
1150: --