APPS.ISC_FS_TASK_PARTY_MERGE_PKG SQL Statements

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

Line: 20

   select merge_reason_code
   from hz_merge_batch
   where batch_id = p_batch_id;

Line: 66

  insert into isc_fs_party_merge_events
  ( send_date
  , event_name
  , source_object_type_code
  , source_object_id
  , task_id
  , created_by
  , creation_date
  , last_updated_by
  , last_update_date
  , last_update_login
  )
  select
    hz_utility_pub.last_update_date
  , 'task_merge_party'
  , 'SR'
  , source_object_id
  , task_id
  , hz_utility_pub.user_id
  , hz_utility_pub.last_update_date
  , hz_utility_pub.user_id
  , hz_utility_pub.last_update_date
  , hz_utility_pub.last_update_login
  from
    isc_fs_tasks_f
  where customer_id = p_from_fk_id;

Line: 117

   select merge_reason_code
   from hz_merge_batch
   where batch_id = p_batch_id;

Line: 164

  insert into isc_fs_party_merge_events
  ( send_date
  , event_name
  , source_object_type_code
  , source_object_id
  , task_id
  , created_by
  , creation_date
  , last_updated_by
  , last_update_date
  , last_update_login
  )
  select
    hz_utility_pub.last_update_date
  , 'task_merge_address'
  , 'SR'
  , source_object_id
  , task_id
  , hz_utility_pub.user_id
  , hz_utility_pub.last_update_date
  , hz_utility_pub.user_id
  , hz_utility_pub.last_update_date
  , hz_utility_pub.last_update_login
  from
    isc_fs_tasks_f
  where address_id = p_from_fk_id;