APPS.ENG_CHANGE_RULE_ATTRIBUTES_PKG SQL Statements

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

Line: 6

  delete from 	ENG_CHANGE_RULE_ATTRIBUTES_TL T
  where not exists
    (select NULL
    from ENG_CHANGE_RULE_ATTRIBUTES_B B
    where B.ATTRIBUTE_OBJECT_NAME = T.ATTRIBUTE_OBJECT_NAME
      and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
    );

Line: 14

  update ENG_CHANGE_RULE_ATTRIBUTES_TL T set (
      ATTRIBUTE_NAME,
      DISPLAY_COLUMN1_NAME,
      DISPLAY_COLUMN2_NAME
    ) = (select
          B.ATTRIBUTE_NAME,
          B.DISPLAY_COLUMN1_NAME,
          B.DISPLAY_COLUMN2_NAME
        from ENG_CHANGE_RULE_ATTRIBUTES_TL B
        where B.ATTRIBUTE_OBJECT_NAME = T.ATTRIBUTE_OBJECT_NAME
          and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
          and B.LANGUAGE = T.SOURCE_LANG)
        where (  T.ATTRIBUTE_OBJECT_NAME,
                 T.ATTRIBUTE_CODE,
                 T.LANGUAGE
              ) in
              (select SUBT.ATTRIBUTE_OBJECT_NAME,
                      SUBT.ATTRIBUTE_CODE,
                      SUBT.LANGUAGE
               from ENG_CHANGE_RULE_ATTRIBUTES_TL SUBB, ENG_CHANGE_RULE_ATTRIBUTES_TL SUBT
               where SUBB.ATTRIBUTE_OBJECT_NAME = SUBT.ATTRIBUTE_OBJECT_NAME
                 and SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
                 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
                      or SUBB.DISPLAY_COLUMN1_NAME <> SUBT.DISPLAY_COLUMN1_NAME
                      or SUBB.DISPLAY_COLUMN2_NAME <> SUBT.DISPLAY_COLUMN2_NAME
                      or (SUBB.DISPLAY_COLUMN2_NAME is null
                          and
                          SUBT.DISPLAY_COLUMN2_NAME is not null)
                      or (SUBB.DISPLAY_COLUMN2_NAME is not null
                          and
                          SUBT.DISPLAY_COLUMN2_NAME is null)
              )
        );

Line: 49

  insert into ENG_CHANGE_RULE_ATTRIBUTES_TL (
    ATTRIBUTE_OBJECT_NAME,
    ATTRIBUTE_CODE,
    ATTRIBUTE_NAME,
    DISPLAY_COLUMN1_NAME,
    DISPLAY_COLUMN2_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.ATTRIBUTE_OBJECT_NAME,
    B.ATTRIBUTE_CODE,
    B.ATTRIBUTE_NAME,
    B.DISPLAY_COLUMN1_NAME,
    B.DISPLAY_COLUMN2_NAME,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from ENG_CHANGE_RULE_ATTRIBUTES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from ENG_CHANGE_RULE_ATTRIBUTES_TL T
    where T.ATTRIBUTE_OBJECT_NAME = B.ATTRIBUTE_OBJECT_NAME
      and T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
      and T.LANGUAGE = L.LANGUAGE_CODE);