APPS_NE.OKC_QUEUE_RULE_PVT SQL Statements

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

Line: 15

SELECT oracle_username INTO l_owner FROM system.FND_ORACLE_USERID WHERE read_only_flag = 'E';

Line: 18

EXECUTE IMMEDIATE 'select fou.oracle_username
from '||l_owner||'.FND_PRODUCT_INSTALLATIONS# FPI,
     '||l_owner||'.FND_ORACLE_USERID# FOU,
     '||l_owner||'.FND_APPLICATION# FA
      where fpi.application_id = fa.application_id
      and   fpi.oracle_id = fou.oracle_id
      and   fa.application_short_name = ''OKC''' INTO l_okc_owner;

Line: 26

EXECUTE IMMEDIATE 'SELECT acn_type
FROM '||l_okc_owner||'.okc_actions_b#
WHERE correlation = :p_corrid' INTO v_acn_type USING p_corrid;