514: decode(adrr.address_id, null, adrc.town_or_city, adrr.town_or_city) district_code,
515: asg.organization_id
516: from per_all_assignments_f asg,
517: per_all_people_f per,
518: per_addresses adrr,
519: per_addresses adrc
520: where asg.assignment_id = cp_assignment_id
521: and cp_effective_date
522: between asg.effective_start_date and asg.effective_end_date
515: asg.organization_id
516: from per_all_assignments_f asg,
517: per_all_people_f per,
518: per_addresses adrr,
519: per_addresses adrc
520: where asg.assignment_id = cp_assignment_id
521: and cp_effective_date
522: between asg.effective_start_date and asg.effective_end_date
523: and per.person_id = asg.person_id