APPS.OTA_COI_SHD SQL Statements

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

Line: 50

    select
       chat_id
      ,object_id
      ,object_type
      ,start_date_active
      ,end_date_active
      ,primary_flag
      ,object_version_number
    from        ota_chat_obj_inclusions
    where       chat_id = p_chat_id
    and   object_id = p_object_id
    and   object_type = p_object_type;

Line: 132

    select
       chat_id
      ,object_id
      ,object_type
      ,start_date_active
      ,end_date_active
      ,primary_flag
      ,object_version_number
    from        ota_chat_obj_inclusions
    where       chat_id = p_chat_id
    and   object_id = p_object_id
    and   object_type = p_object_type
    for update nowait;