DBA Data[Home] [Help]

APPS.CN_COLLECT_CLAWBACKS SQL Statements

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

Line: 141

  select
    NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
                         SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
  into cached_org_id
  from dual;