APPS.HRI_OLTP_PMV_WMV_SAL_SUP_GRAPH SQL Statements

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

Line: 62

'SELECT -- Headcount and Salary 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
,qry.period_hdc               HRI_P_WMV_SUM_MV
,qry.period_sal_end           HRI_P_SAL_ANL_CUR_PARAM_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 ';