[Home] [Help]
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 (
38: p_effective_date_c BETWEEN paf.effective_start_date