APPS.HRI_OLTP_PMV_WMV_C_EXTN_GRAPH SQL Statements

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

Line: 67

'SELECT -- Contingent Worker Placement (with Extension) Trend
 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_pasg_cnt
          ,0,0
          ,((qry.period_pasg_pow - qry.period_extn_pow)
            /(qry.period_pasg_cnt*:MONTHS_MULTIPLIER))
        )                     HRI_P_MEASURE1
,DECODE(qry.period_pasg_cnt
          ,0,0
          ,((qry.period_extn_pow)/(period_pasg_cnt*:MONTHS_MULTIPLIER))
        )                     HRI_P_MEASURE2
,DECODE(qry.period_pasg_cnt
          ,0,0
          ,((qry.period_pasg_pow)/(period_pasg_cnt*:MONTHS_MULTIPLIER))
        )                     HRI_P_MEASURE3
,qry.period_pasg_cnt      HRI_P_MEASURE4
,((qry.period_pasg_pow)/:MONTHS_MULTIPLIER)
                              HRI_P_MEASURE5
,qry.period_extn_cnt      HRI_P_MEASURE6
,((qry.period_extn_pow)/:MONTHS_MULTIPLIER)
                              HRI_P_MEASURE7
,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 ';