APPS.PON_CONTRACTS_TL_PKG SQL Statements

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

Line: 7

    INSERT INTO PON_CONTRACTS_TL (
      CONTRACT_ID,
      VERSION_NUM,
      TITLE,
      ABSTRACT,
      BODY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      language,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      source_lang
    )
    SELECT
      cont.CONTRACT_ID,
      cont.VERSION_NUM,
      cont.TITLE,
      cont.ABSTRACT,
      cont.BODY,
      cont.ATTRIBUTE1,
      cont.ATTRIBUTE2,
      cont.ATTRIBUTE3,
      cont.ATTRIBUTE4,
      cont.ATTRIBUTE5,
      lang.language_code,
      cont.created_by,
      SYSDATE,
      cont.last_updated_by,
      SYSDATE,
      cont.source_lang
    FROM pon_contracts_tl cont,
         fnd_languages lang
    WHERE cont.language = USERENV('LANG')
    AND lang.INSTALLED_FLAG in ('I', 'B')
    AND NOT EXISTS (SELECT NULL
                      FROM pon_contracts_tl cont2
                     WHERE cont2.contract_id = cont.contract_id
                     and cont2.version_num = cont.version_num
                       AND cont2.language   = lang.language_code);