APPS.PO_VENDOR_SITES_SV1 dependencies on PO_SUPPLIER_SITES_VAL_V

Line 20: Get the vendor site id from po_supplier_sites_val_v based on

16: BEGIN
17:
18: X_progress := '010';
19: /*
20: Get the vendor site id from po_supplier_sites_val_v based on
21: the parameters supplied from the input. */
22:
23: SELECT vendor_site_id
24: INTO X_vendor_site_id_v

Line 25: FROM po_supplier_sites_val_v

21: the parameters supplied from the input. */
22:
23: SELECT vendor_site_id
24: INTO X_vendor_site_id_v
25: FROM po_supplier_sites_val_v
26: WHERE vendor_id = X_vendor_id
27: AND vendor_site_code = X_vendor_site_code;
28:
29: RETURN X_vendor_site_id_v;