APPS.PER_PERRPRPH_XMLP_PKG SQL Statements

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

Line: 88

 select nvl(count(*),0)
 into   v_count_child_pos
 from   per_pos_structure_elements pse
 where  pse.pos_structure_version_id = p_pos_structure_version_id
   --and  pse.parent_position_id = parent_position_id;

Line: 109

  select count(*)
  into   v_count_holders
  from   per_people_f peo,
         per_assignments_f asg
  where  peo.person_id = asg.person_id
    and  asg.position_id = parent_position_id
    and  c_session_date between peo.effective_start_date
                             and peo.effective_end_date
    and  c_session_date between asg.effective_start_date
                             and asg.effective_end_date
        and peo.current_employee_flag = 'Y'
    and asg.assignment_type <> 'A';

Line: 136

  select count(*)
  into   v_count_holders
  from   per_people_f peo,
         per_assignments_f asg
  where  peo.person_id = asg.person_id
    and  asg.position_id = subordinate_position_id
    and  c_session_date between peo.effective_start_date
                             and peo.effective_end_date
    and  c_session_date between asg.effective_start_date
                             and asg.effective_end_date
    and peo.current_employee_flag = 'Y'
  and asg.assignment_type <> 'A';