APPS.HRI_OLTP_PMV_WMV_WF_SUP_GRAPH SQL Statements

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

Line: 66

  /* use selective drill across feature */
  -- drill to employee detail report
  l_drill_url2 := 'pFunctionName=HRI_P_WMV_SAL_SUP_DTL&' ||
                  'VIEW_BY=HRI_PERSON+HRI_PER_USRDR_H&' ||
                  'VIEW_BY_NAME=VIEW_BY_ID&' ||
                  'pParamIds=Y';

Line: 82

'SELECT -- Workforce Ratio 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_MEASURE1
,qry.period_hdc_emp           HRI_P_MEASURE2
,'''|| l_drill_url2 ||'''     HRI_P_DRILL_URL2
,qry.period_hdc_cwk           HRI_P_MEASURE3
,'''|| l_drill_url3 ||'''     HRI_P_DRILL_URL3
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_emp/qry.period_hdc)*100)
                              HRI_P_MEASURE2_MP
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_cwk/qry.period_hdc)*100)
                              HRI_P_MEASURE3_MP
,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 ';