APPS.EDW_OPI_ACTV_MOPM_SZ SQL Statements

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

Line: 10

    SELECT count(*) into p_num_rows
    FROM FM_ACTV_MST FA
    WHERE FA.last_update_date between p_from_date and p_to_date;

Line: 33

    x_last_update_date     NUMBER := x_date;

Line: 36

      select avg(nvl(vsize(instance_code),0))
      from edw_local_instance;

Line: 40

      SELECT avg(nvl(vsize(ACTIVITY),0)),
             avg(nvl(vsize(ACTIVITY_DESC),0)),
             avg(nvl(vsize(COST_ANALYSIS_CODE),0)),
             avg(nvl(vsize(ACTIVITY||'-'||'OPM'||'-'),0)) ACT_PK,
             avg(vsize('ACTV'))
      FROM FM_ACTV_MST
      WHERE LAST_UPDATE_DATE BETWEEN P_FROM_DATE AND P_TO_DATE;