APPS.IGI_CIS_CI36_DATA_PKG dependencies on PO_VENDOR_SITES

Line 312: WHERE EXISTS (SELECT 'x' FROM po_vendor_sites b

308:
309:
310: /* remove the vendor sites which does not have automatic withholding tax */
311: DELETE FROM igi_cis_ci36_payments a
312: WHERE EXISTS (SELECT 'x' FROM po_vendor_sites b
313: WHERE b.vendor_site_id = a.vendor_site_id
314: AND ( nvl(b.allow_awt_flag,'N') <> 'Y'
315: OR b.awt_group_id <> a.group_id));
316:

Line 339: FROM po_vendor_sites b

335: /* updating with proper vendor site code for the corresponding vendor site id */
336: UPDATE igi_cis_ci36_payments a
337: SET (a.vendor_site_code,a.address_line1,A.address_line2,A.address_line3,a.zip ) =
338: (SELECT vendor_site_code,address_line1,address_line2,address_line3,zip
339: FROM po_vendor_sites b
340: WHERE b.vendor_site_id = a.vendor_site_id );
341: COMMIT;
342:
343: