APPS.PO_VENDOR_CONTACTS_SV SQL Statements

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

Line: 22

  SELECT  vendor_contact_id
  INTO    X_vendor_contact_id_v
  FROM    po_vendor_contacts
  WHERE   sysdate < nvl(inactive_date, sysdate + 1)
  AND     vendor_contact_id = p_vendor_contact_id
  AND     vendor_site_id = p_vendor_site_id; --

Line: 61

   SELECT count(vendor_contact_id),
          -- bug 590653: need to handle null first_name
          -- max((last_name||', '||first_name)),
          max((last_name || decode(first_name,null,null,', ') || first_name)),
          max(vendor_contact_id)
   INTO   X_vendor_contact_count,
          X_vendor_contact_name,
          X_vendor_contact_id
   FROM   po_vendor_contacts
   WHERE  vendor_site_id       = X_vendor_site_id
   AND    sysdate < nvl(inactive_date, sysdate + 1);

Line: 119

    SELECT pvc.last_name || decode(pvc.last_name,null,null,
				   decode(pvc.first_name,null,null,', '))
			 || pvc.first_name,
	decode(trunc(length(pvc.area_code ||' '||pvc.phone)/26),0,
	pvc.area_code || decode(pvc.area_code,null,null,decode(pvc.phone,null,null,' '))||pvc.phone,
	pvc.area_code||pvc.phone )

    INTO  x_vendor_contact_name,
	  x_vendor_phone
    FROM  po_vendor_contacts pvc
    WHERE pvc.vendor_contact_id = x_vendor_contact_id
    AND   pvc.vendor_site_id = nvl(x_vendor_site_id,pvc.vendor_site_id);

Line: 175

    SELECT    vendor_contact_id
    INTO      x_vendor_contact_id
    FROM      po_headers_all
    WHERE     po_header_id = p_po_header_id;