DBA Data[Home] [Help]

APPS.OKI_ALERT_UTIL_PVT SQL Statements

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

Line: 82

        select OKI_ALERT_WF_S1.NEXTVAL into wf_itemkey_seq from dual;
Line: 432

  SELECT qtr_end_date
  FROM   oki_graph_values
  WHERE  p_curr_date between qtr_start_date and qtr_end_date
  AND graph_code = 'OKI_SEQ_GRW'
  AND authoring_org_id = p_authoring_org_id
  AND ROWNUM < 2
  ;