The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_sql_stmt := ' SELECT COUNT(*) ' ||
' FROM igc_cc_routing_ctrls'||
' WHERE NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV(''CLIENT_INFO''),1,1), '' '', NULL, SUBSTRB(USERENV(''CLIENT_INFO''),1,10))),-99)) '||
' = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV(''CLIENT_INFO''),1,1), '' '', NULL,SUBSTRB(USERENV(''CLIENT_INFO''),1,10))),-99)';
l_sql_stmt := ' SELECT COUNT(*) ' ||
' FROM igc_cc_bc_enable ' ||
' WHERE (NVL(cc_bc_enable_flag,''N'') = ''Y''' ||
' OR NVL(cbc_po_enable, ''N'') = ''Y'')';