3819: ) return number is
3820:
3821: CURSOR csr_count is
3822: select count(distinct(d.person_id))
3823: from per_all_people_f d
3824: ,per_all_people_f p
3825: ,per_contact_relationships pcr
3826: ,per_all_assignments_f asg
3827: where asg.assignment_id = P_assignment_id
3820:
3821: CURSOR csr_count is
3822: select count(distinct(d.person_id))
3823: from per_all_people_f d
3824: ,per_all_people_f p
3825: ,per_contact_relationships pcr
3826: ,per_all_assignments_f asg
3827: where asg.assignment_id = P_assignment_id
3828: and asg.business_group_id = p_business_Group_id