APPS.XLE_PARTY_MERGE_PUB SQL Statements

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

Line: 28

  Select 'X' from
  XLE_REGISTRATIONS
  Where issuing_authority_id = p_from_fk_id
  for update nowait;

Line: 34

  Select 'X' from
  XLE_REGISTRATIONS
  Where issuing_authority_site_id = p_from_fk_id
  for update nowait;

Line: 44

   SELECT merge_reason_code
   INTO   l_merge_reason_code
   FROM   hz_merge_batch
   WHERE  batch_id  = p_batch_id;

Line: 86

         /*  Update the "From" Party_ID to be equal to the new target  */
         UPDATE XLE_REGISTRATIONS
         SET issuing_authority_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE issuing_authority_id = p_From_FK_id;

Line: 107

         UPDATE XLE_REGISTRATIONS
         SET issuing_authority_site_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE issuing_authority_site_id = p_From_FK_id;

Line: 157

  Select 'X' from
  XLE_REG_FUNCTIONS
  Where authority_id = p_from_fk_id
  for update nowait;

Line: 163

  Select 'X' from
  XLE_REG_FUNCTIONS
  Where authority_site_id = p_from_fk_id
  for update nowait;

Line: 174

   SELECT merge_reason_code
   INTO   l_merge_reason_code
   FROM   hz_merge_batch
   WHERE  batch_id  = p_batch_id;

Line: 217

         /*  Update the "From" Party_ID to be equal to the new target  */
         UPDATE XLE_REG_FUNCTIONS
         SET authority_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE authority_id = p_From_FK_id;

Line: 237

         UPDATE XLE_REG_FUNCTIONS
         SET authority_site_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE authority_site_id = p_From_FK_id;