APPS.EDW_HR_PERSON_PKG SQL Statements

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

Line: 25

     select instance_code into l_instance
     from edw_local_instance;

Line: 66

     select instance_code into l_instance
     from edw_local_instance;

Line: 108

     select instance_code into l_instance
     from edw_local_instance;

Line: 134

   SELECT agent_id into l_tmp
   FROM po_agents
   WHERE agent_id = p_person_id
   AND rownum < 2;

Line: 163

  SELECT employee_id into l_tmp
  FROM mtl_planners
  WHERE employee_id = p_person_id
  AND rownum < 2;

Line: 192

  SELECT person_id into l_tmp
  FROM ra_salesreps_all
  WHERE person_id = p_person_id
  AND rownum < 2;