22: select hou.name
23: from hr_soft_coding_keyflex sck
24: ,HR_ORGANIZATION_INFORMATION hoi
25: ,per_all_assignments_f paa
26: ,HR_ORGANIZATION_UNITS hou
27: where paa.assignment_id = p_assignment_id
28: and p_effective_date between paa.effective_start_date and paa.effective_end_date
29: and paa.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
30: and hoi.organization_id = to_number(sck.segment2)