APPS.OTA_FOI_SHD SQL Statements

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

Line: 55

    select
       forum_id
      ,object_id
      ,object_type
      ,start_date_active
      ,end_date_active
      ,primary_flag
      ,object_version_number
    from        ota_frm_obj_inclusions
    where       forum_id = p_forum_id
    and   object_id = p_object_id
    and   object_type = p_object_type;

Line: 137

    select
       forum_id
      ,object_id
      ,object_type
      ,start_date_active
      ,end_date_active
      ,primary_flag
      ,object_version_number
    from        ota_frm_obj_inclusions
    where       forum_id = p_forum_id
    and   object_id = p_object_id
    and   object_type = p_object_type
    for update nowait;