8: per_all_assignments_f pasf
9: where papf.effective_end_date >= to_date('01/03/2010','DD/MM/YYYY')
10: and papf.person_id = p_person_id
11: and papf.business_group_id in (select business_group_id
12: from per_business_groups
13: where legislation_code='ZA')
14: and papf.person_id = pasf.person_id
15: and pasf.primary_flag = 'Y';
16: