262: /***************** This is for the log file ******************/
263:
264: /* deleting all black listed vendors */
265: DELETE FROM igi_cis_ci36_payments a
266: WHERE EXISTS (SELECT 'x' FROM po_vendors b
267: WHERE b.vendor_id = a.vendor_id
268: AND nvl(b.enabled_flag,'N') <> 'Y');
269:
270: /***************** This is for the log file ******************/
285: /* updating the vendor name for the corresponding vendor id */
286:
287: UPDATE igi_cis_ci36_payments a
288: SET (a.vendor_name,a.segment1) =
289: (SELECT vendor_name,segment1 FROM po_vendors
290: WHERE vendor_id = a.vendor_id);
291: COMMIT;
292:
293: /***************** This is for the log file ******************/