709: SELECT COUNT(1)
710: FROM (
711: SELECT ass.location_id
712: FROM per_all_assignments_f ass,
713: hr_organization_units_v hou,
714: per_all_people_f peo
715: WHERE ass.organization_id = hou.organization_id
716: AND ass.person_id = peo.person_id
717: AND p_report_date between ass.effective_start_date and ass.effective_end_date
726:
727:
728: CURSOR csr_schools(p_business_group_id IN NUMBER) IS
729: SELECT COUNT(1)
730: FROM hr_organization_units_v hou
731: WHERE hou.business_group_id = p_business_group_id;
732: l_count_schools NUMBER := 0;
733:
734: CURSOR csr_district_id(p_business_group_id IN NUMBER) IS