APPS.WIP_WF_UPDATE_DATE dependencies on PO_VENDORS

Line 34: x_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;

30: x_org_id number;
31: x_qty_ordered number;
32: x_uom varchar2(25);
33: x_curr_promise_date date;
34: x_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;
35: x_subcontractor_site VARCHAR2(80);
36:
37:
38: BEGIN

Line 89: from po_vendors pv, po_vendor_sites_all pvs, po_headers_all ph

85: /* get vendor data */
86: begin
87: select pv.vendor_name, pvs.vendor_site_code
88: into x_subcontractor_name, x_subcontractor_site
89: from po_vendors pv, po_vendor_sites_all pvs, po_headers_all ph
90: where ph.po_header_id = x_po_header_id
91: and pv.vendor_id = ph.vendor_id
92: and pvs.vendor_site_id = ph.vendor_site_id
93: and pvs.org_id = ph.org_id;