APPS.XLA_CMP_LOCK_PKG SQL Statements

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

Line: 111

   SELECT xtatb.account_type_code
     FROM xla_tab_acct_types_b   xtatb
         ,xla_tab_acct_type_srcs xtsrc
         ,xla_sources_b          xsb
    WHERE xtatb.application_id     = p_application_id
      AND xtatb.enabled_flag       = 'Y'
      AND xtsrc.account_type_code  = xtatb.account_type_code
      AND xsb.application_id       = xtsrc.source_application_id
      AND xsb.source_code          = xtsrc.source_code
      AND xsb.source_type_code     = xtsrc.source_type_code
   FOR UPDATE NOWAIT;