APPS.HXC_HAN_SHD SQL Statements

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

Line: 49

    select
       comp_notification_id
      ,object_version_number
      ,notification_number_retries
      ,notification_timeout_value
      ,notification_action_code
      ,notification_recipient_code
    from        hxc_app_comp_notifications
    where       comp_notification_id = p_comp_notification_id
    and   object_version_number = p_object_version_number;

Line: 121

    select
       comp_notification_id
      ,object_version_number
      ,notification_number_retries
      ,notification_timeout_value
      ,notification_action_code
      ,notification_recipient_code
    from        hxc_app_comp_notifications
    where       comp_notification_id = p_comp_notification_id
    and   object_version_number = p_object_version_number
    for update nowait;