29: ,p_assignment_set_id_c IN number) IS
30: SELECT DISTINCT
31: paf.assignment_id
32: FROM per_all_assignments_f paf
33: ,per_business_groups pbf
34: ,hr_assignment_set_amendments hasa
35: WHERE pbf.legislation_code = 'GB'
36: AND pbf.business_group_id = paf.business_group_id
37: AND (