APPS.HRI_EDW_DIM_PERSON SQL Statements

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

Line: 14

  SELECT supv_person_id
  FROM hri_supv_hrchy_summary
  WHERE sub_person_id = p_person_id
  AND supv_level = 14;

Line: 39

  SELECT agent_id INTO l_temp
  FROM po_agents
  WHERE agent_id = p_person_id
  AND rownum < 2;

Line: 66

  SELECT employee_id INTO l_temp
  FROM mtl_planners
  WHERE employee_id = p_person_id
  AND rownum < 2;

Line: 93

  SELECT person_id INTO l_temp
  FROM ra_salesreps_all
  WHERE person_id = p_person_id
  AND rownum < 2;