APPS.HZ_DUP_MERGE_PUB SQL Statements

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

Line: 55

    SELECT status, party_id
    FROM HZ_PARTIES
    WHERE party_id = l_pty_id
    AND status in ('A', 'I');

Line: 260

  select party_name
  from HZ_PARTIES
  where party_id = l_party_id;

Line: 375

     	update hz_dup_batch
     	set dup_batch_name = l_party_name || ' - '||l_dup_batch_id
        where dup_batch_id = l_dup_batch_id;

Line: 427

   		,p_last_update_date	=> sysdate
   		,p_last_updated_by   =>fnd_global.user_id
   		,p_creation_date     => sysdate
   		,p_created_by        => fnd_global.user_id
   		,p_last_update_login	=> fnd_global.login_id
   		,p_attribute1		   => NULL
    		,p_attribute2		   => NULL
    		,p_attribute3		   => NULL
    		,p_attribute4		   => NULL
    		,p_attribute5		   => NULL
    		,p_attribute6		   => NULL
    		,p_attribute7		   => NULL
    		,p_attribute8		   => NULL
    		,p_attribute9		   => NULL
    		,p_attribute10		   => NULL
    		,p_attribute11		   => NULL
    		,p_attribute12		   => NULL
    		,p_attribute13		   => NULL
    		,p_attribute14		   => NULL
    		,p_attribute15		   => NULL
    		,p_context			   => NULL
    		,p_note_type                   => 'GENERAL'
 	);