DBA Data[Home] [Help]

APPS.PAY_DK_SOE dependencies on HR_ORGANIZATION_UNITS

Line 26: ,HR_ORGANIZATION_UNITS hou

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)