APPS.LNS_ASSETS_PKG SQL Statements

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

Line: 7

      delete from LNS_ASSETS_TL T
      where not exists
        (select NULL
        from LNS_ASSETS B
        where B.ASSET_ID = T.ASSET_ID
        );

Line: 14

      update LNS_ASSETS_TL T set (
          DESCRIPTION
        ) = (select
          B.DESCRIPTION
        from LNS_ASSETS_TL B
        where B.ASSET_ID = T.ASSET_ID
        and B.LANGUAGE = T.SOURCE_LANG)
      where (
          T.ASSET_ID,
          T.LANGUAGE
      ) in (select
          SUBT.ASSET_ID,
          SUBT.LANGUAGE
        from LNS_ASSETS_TL SUBB, LNS_ASSETS_TL SUBT
        where SUBB.ASSET_ID = SUBT.ASSET_ID
        and SUBB.LANGUAGE = SUBT.SOURCE_LANG
        and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
          or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
          or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
      ));

Line: 35

      insert into LNS_ASSETS_TL (
        ASSET_ID,
        DESCRIPTION,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN,
        LANGUAGE,
        SOURCE_LANG
      ) select
        B.ASSET_ID,
        B.DESCRIPTION,
        B.LAST_UPDATE_DATE,
        B.LAST_UPDATED_BY,
        B.CREATION_DATE,
        B.CREATED_BY,
        B.LAST_UPDATE_LOGIN,
        L.LANGUAGE_CODE,
        B.SOURCE_LANG
      from LNS_ASSETS_TL B, FND_LANGUAGES L
      where L.INSTALLED_FLAG in ('I', 'B')
      and B.LANGUAGE = userenv('LANG')
      and not exists
        (select NULL
        from LNS_ASSETS_TL T
        where T.ASSET_ID = B.ASSET_ID
        and T.LANGUAGE = L.LANGUAGE_CODE);