APPS.HRI_OLTP_PMV_WMV_HR_CTR SQL Statements

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

Line: 61

'SELECT -- HR Staff KPIs
 vby.id                         VIEWBYID
,vby.value                      VIEWBY
,tab.curr_hdc_end               HRI_P_MEASURE1
,tab.comp_hdc_end               HRI_P_MEASURE2
,tab.curr_hdc_hr                HRI_P_MEASURE3
,tab.comp_hdc_hr                HRI_P_MEASURE4
,DECODE(tab.curr_hdc_hr,
          0, to_number(null),
        tab.curr_hdc_end / tab.curr_hdc_hr)
                                HRI_P_MEASURE5
,DECODE(tab.comp_hdc_hr,
          0, to_number(null),
        tab.comp_hdc_end / tab.comp_hdc_hr)
                                HRI_P_MEASURE6
,tab.curr_hdc_end               HRI_P_GRAND_TOTAL1
,tab.comp_hdc_end               HRI_P_GRAND_TOTAL2
,tab.curr_hdc_hr                HRI_P_GRAND_TOTAL3
,tab.comp_hdc_hr                HRI_P_GRAND_TOTAL4
,DECODE(tab.curr_hdc_hr,
          0, to_number(null),
        tab.curr_hdc_end / tab.curr_hdc_hr)
                                HRI_P_GRAND_TOTAL5
,DECODE(tab.comp_hdc_hr,
          0, to_number(null),
        tab.comp_total_hdc_end / tab.comp_hdc_hr)
                                HRI_P_GRAND_TOTAL6
FROM
 hri_dbi_cl_per_n_v  vby
,(' || l_wrkfc_fact_sql || ')  tab
WHERE tab.vby_id = vby.id
AND &BIS_CURRENT_ASOF_DATE BETWEEN vby.effective_start_date
                          AND vby.effective_end_date ';

Line: 162

'SELECT -- HR Staff Ratio by Country
 vby.value                      HRI_P_GEO_CTY_CN
,tab.curr_hdc_end               HRI_P_MEASURE1
,tab.comp_hdc_end               HRI_P_MEASURE2
,tab.curr_hdc_hr                HRI_P_MEASURE3
,tab.comp_hdc_hr                HRI_P_MEASURE4
,ROUND(DECODE(tab.curr_hdc_hr,
          0, to_number(null),
        tab.curr_hdc_end / tab.curr_hdc_hr),0)
                                HRI_P_MEASURE5
,DECODE(tab.comp_hdc_hr,
          0, to_number(null),
        tab.comp_hdc_end / tab.comp_hdc_hr)
                                HRI_P_MEASURE6
,SUM(tab.curr_hdc_end) OVER ()  HRI_P_GRAND_TOTAL1
,tab.comp_total_hdc_end         HRI_P_GRAND_TOTAL2
,SUM(tab.curr_hdc_hr) OVER ()   HRI_P_GRAND_TOTAL3
,tab.comp_total_hdc_hr          HRI_P_GRAND_TOTAL4
,DECODE(SUM(tab.curr_hdc_hr) OVER (),
          0, to_number(null),
        SUM(tab.curr_hdc_end) OVER () / SUM(tab.curr_hdc_hr) OVER ())
                                HRI_P_GRAND_TOTAL5
,DECODE(SUM(tab.comp_total_hdc_hr) OVER (),
          0, to_number(null),
        SUM(tab.comp_total_hdc_end) OVER () / SUM(tab.comp_total_hdc_hr) OVER ())
                                HRI_P_GRAND_TOTAL6
,0 - tab.curr_hdc_end           HRI_P_ORDER_BY_1
,tab.vby_id                     HRI_P_CHAR1_GA
FROM
 hri_dbi_cl_geo_country_v  vby
,(' || l_wrkfc_fact_sql || ')  tab
WHERE vby.id = tab.vby_id
ORDER BY ' || hri_oltp_pmv_util_pkg.set_default_order_by
               (p_order_by_clause => l_parameter_rec.order_by);