APPS.HRI_OLTP_PMV_ABS_CAT SQL Statements

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

Line: 63

/* Get the top 4 Absence Categories for selection Mgr on effective date */
  hri_oltp_pmv_rank_abs.set_top_categories
   (p_supervisor_id  => l_parameter_rec.peo_supervisor_id,
    p_effective_from_date => l_parameter_rec.time_curr_start_date,
    p_effective_to_date => l_parameter_rec.time_curr_end_date,
    p_no_categories  => 4,
    p_category_tab   => l_abs_category_tab);

Line: 143

'SELECT -- Employee Absence Top 4 Categories Trend
 qry.period_as_of_date     VIEWBYID
,qry.period_as_of_date     VIEWBY
,qry.period_order          HRI_P_ORDER_BY_1
,'||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
,'||l_period_abs_drtn_metric3 ||'   HRI_P_MEASURE3
,''' || l_drill_url3 || '''         HRI_P_DRILL_URL3
,'||l_period_abs_drtn_metric4 ||'   HRI_P_MEASURE4
,''' || l_drill_url4 || '''         HRI_P_DRILL_URL4
,to_char(qry.period_as_of_date,''DD/MM/YYYY'')   HRI_P_CHAR2_GA
FROM
 (' || l_trend_sql || ')  qry
WHERE 1=1
'
|| l_security_clause ||
' ORDER BY
  period_order';

Line: 264

  /* formulate the dynmaic column selection based on Absence Duration
     unit of measure paramter selection  Default Days                */

     IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
        l_dynmc_drtn_curr := 'curr_abs_drtn_days';

Line: 292

SELECT
 babs.vby_id											VIEWBYID
,babs.value												VIEWBY'|| g_rtn
/* Absence  */ || g_rtn ||'
,NVL(babs.curr_abs_drtn,to_number(NULL))                HRI_P_MEASURE1 '|| g_rtn
/* Total Absence  */ || g_rtn ||'
,NVL(babs.curr_tot_abs_drtn,to_number(NULL))   		    HRI_P_GRAND_TOTAL1'|| g_rtn
/* Drill URLs */ || g_rtn ||'
,'''|| l_drill_abs_detail ||'''	                        HRI_P_DRILL_URL1
FROM
(
SELECT
/* Base Measures */
 vby.id                   				          vby_id
,vby.value                                        value
,vby.order_by                                     order_by
,NVL(afact.'|| l_dynmc_drtn_curr ||',0)           curr_abs_drtn
,SUM(afact.'|| l_dynmc_drtn_curr ||') OVER()      curr_tot_abs_drtn

FROM
 hri_cl_absnc_cat_v  vby
,('|| l_abs_fact_sql ||') afact
WHERE
   vby.id = afact.vby_id
 ' || l_security_clause || ') babs' || g_rtn ||
'&ORDER_BY_CLAUSE';