APPS.HRI_OLTP_PMV_WMV_TRN_SUP_GRAPH SQL Statements

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

Line: 66

SELECT
 qry.period_as_of_date      VIEWBYID
,qry.period_as_of_date      VIEWBY
,qry.period_order           HRI_P_ORDER_BY_1
,qry.period_as_of_date      HRI_P_GRAPH_X_LABEL_TIME
,DECODE(qry.period_sep_vol_hdc,
          0, 0,
        ((qry.period_sep_vol_hdc * :ANL_FACTOR /
         DECODE(qry.period_hdc_trn,
                  0, (qry.period_sep_vol_hdc + qry.period_sep_invol_hdc),
                qry.period_hdc_trn)) * 100))
                            HRI_P_WMV_TRN_SEP_VOL_ANL_MV
,DECODE(qry.period_sep_invol_hdc,
          0, 0,
        ((qry.period_sep_invol_hdc * :ANL_FACTOR /
         DECODE(qry.period_hdc_trn,
                  0, (qry.period_sep_vol_hdc + qry.period_sep_invol_hdc),
                qry.period_hdc_trn)) * 100))
                            HRI_P_WMV_TRN_SEP_INV_ANL_MV
,DECODE(qry.period_sep_vol_hdc + qry.period_sep_invol_hdc,
          0, 0,
        (((qry.period_sep_vol_hdc + qry.period_sep_invol_hdc) * :ANL_FACTOR /
          DECODE(qry.period_hdc_trn,
                   0, (qry.period_sep_vol_hdc + qry.period_sep_invol_hdc),
                 qry.period_hdc_trn)) * 100))
                            HRI_P_WMV_TRN_ANL_SUM_MV
,to_char(qry.period_as_of_date,''DD/MM/YYYY'')
                            HRI_P_CHAR1_GA
FROM
 ('|| l_trend_sql || ')  qry
WHERE 1 = 1
' || l_security_clause || '
ORDER BY qry.period_order ASC';