APPS.HRI_OLTP_PMV_WMV_ABS_SUP_GRAPH SQL Statements

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

Line: 125

'SELECT -- Employee Absence 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
,'||l_period_abs_drtn_metric1 ||'   HRI_P_MEASURE1
,''' || l_drill_url1 || '''         HRI_P_DRILL_URL1
,'||l_period_abs_drtn_metric2 ||'   HRI_P_MEASURE2
,''' || l_drill_url2 || '''         HRI_P_DRILL_URL2
,qry.period_abs_in_period         HRI_P_MEASURE3
,''' || l_drill_url3 || '''         HRI_P_DRILL_URL3
,qry.period_hdc_abs        HRI_P_MEASURE4
,''' || l_drill_url4 || '''         HRI_P_DRILL_URL4
,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
  period_order';