APPS.POS_VENDOR_MERGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

select count(*)
into l_count
from po_vendor_sites_all
where vendor_id = p_dup_vendor_id
and vendor_site_id <> p_dup_vendor_site_id
and
(inactive_date is null OR inactive_date >= sysdate) ;