APPS.HRI_OLTP_PMV_WMV_BCKT_GRAPH SQL Statements

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

Line: 60

'SELECT -- Headcount with LOW Band Trend
 qry.period_as_of_date             VIEWBYID
,qry.period_as_of_date            VIEWBY
,qry.period_order           HRI_P_ORDER_BY_1
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_b1/qry.period_hdc)*100)
                        HRI_P_MEASURE1
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_b2/qry.period_hdc)*100)
                        HRI_P_MEASURE2
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_b3/qry.period_hdc)*100)
                        HRI_P_MEASURE3
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_b4/qry.period_hdc)*100)
                        HRI_P_MEASURE4
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_b5/qry.period_hdc)*100)
                        HRI_P_MEASURE5
,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';

Line: 168

'SELECT -- Headcount with Performance Band Trend
 qry.period_as_of_date             VIEWBYID
,qry.period_as_of_date             VIEWBY
,qry.period_order           HRI_P_ORDER_BY_1
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_b3/qry.period_hdc)*100)
                        HRI_P_MEASURE1
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_b2/qry.period_hdc)*100)
                        HRI_P_MEASURE2
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_b1/qry.period_hdc)*100)
                        HRI_P_MEASURE3
,DECODE(qry.period_hdc, 0, 0,
        (qry.period_hdc_na/qry.period_hdc)*100)
                        HRI_P_MEASURE4
,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';