APPS.HRI_OLTP_PMV_RANK_ABS SQL Statements

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

Line: 31

  SELECT
   top.category_code
  ,cat.value             category_name
  ,top.category_rank
  FROM
   hri_cl_absnc_cat_v  cat
  ,(SELECT
     tab.category_code
    ,tab.abs_drtn_days
    ,ROWNUM     category_rank
    FROM
       (SELECT
         SUM(fact.abs_drtn_days)      abs_drtn_days
        ,fact.absence_category_code   category_code
        FROM
           hri_mdp_sup_absnc_cat_mv  fact
        WHERE fact.supervisor_person_id = p_supervisor_id
        AND fact.effective_date BETWEEN p_effective_from_date AND p_effective_to_date
        GROUP BY
          fact.absence_category_code
        ORDER BY
          SUM(fact.abs_drtn_days) DESC
         ,fact.absence_category_code
     )  tab
    WHERE ROWNUM <= g_max_no_categories
   )  top
  WHERE top.category_code = cat.id;