APPS.PER_PERRPROH_XMLP_PKG SQL Statements

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

Line: 11

    SELECT business_group_id
      FROM per_org_structure_versions
     WHERE org_structure_version_id = p_org_structure_version_id;

Line: 104

  select count(*)
  into v_count_child_orgs
  from per_org_structure_elements ose
  where ose.org_structure_version_id = p_org_structure_version_id
    --and ose.organization_id_parent = organization_id_parent;

Line: 128

  select count(*)
  into   v_count_managers
  from   per_people_f peo,
         per_assignments_f asg
  where  peo.person_id = asg.person_id
    and  asg.assignment_type in ('E','C')      and  asg.manager_flag = 'Y'
    and  asg.organization_id = organization_id_parent
    and  c_session_date between asg.effective_start_date
                             and asg.effective_end_date
    and  c_session_date between peo.effective_start_date
                             and peo.effective_end_date;

Line: 154

  select count(*)
  into   v_count_managers
  from   per_people_f peo,
         per_assignments_f asg
  where  peo.person_id = asg.person_id
    and  asg.assignment_type in ('E','C')      and  asg.manager_flag = 'Y'
    and  asg.organization_id = organization_id_child
    and  c_session_date between asg.effective_start_date
                             and asg.effective_end_date
    and  c_session_date between peo.effective_start_date
                             and peo.effective_end_date;