APPS.HRI_OLTP_PMV_RANK_CTR SQL Statements

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

Line: 29

  SELECT
   top.country_code
  ,ctr.value             country_name
  ,top.country_rank
  FROM
   hri_dbi_cl_geo_country_v  ctr
  ,(SELECT
     tab.country_code
    ,tab.total_headcount
    ,ROWNUM     country_rank
    FROM
     (SELECT
       hc.geo_country_code      country_code
      ,SUM(hc.total_headcount)  total_headcount
      FROM
       hri_mdp_sup_wrkfc_ctr_mv  hc
      WHERE hc.supervisor_person_id = p_supervisor_id
      AND p_effective_date BETWEEN effective_start_date AND effective_end_date
      GROUP BY
       hc.geo_country_code
      ORDER BY
       SUM(hc.total_headcount) DESC
      ,hc.geo_country_code
     )  tab
    WHERE ROWNUM <= g_max_no_countries
   )  top
  WHERE top.country_code = ctr.id;