127: and hsk.enabled_flag = 'Y'
128: and hsk.segment2 in (
129: select hoi2.org_information1
130: from HR_ORGANIZATION_UNITS o1
131: , HR_ORGANIZATION_INFORMATION hoi1
132: , HR_ORGANIZATION_INFORMATION hoi2
133: WHERE o1.business_group_id = pa1.business_group_id
134: and hoi1.organization_id = o1.organization_id
135: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter
128: and hsk.segment2 in (
129: select hoi2.org_information1
130: from HR_ORGANIZATION_UNITS o1
131: , HR_ORGANIZATION_INFORMATION hoi1
132: , HR_ORGANIZATION_INFORMATION hoi2
133: WHERE o1.business_group_id = pa1.business_group_id
134: and hoi1.organization_id = o1.organization_id
135: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter
136: (pa1.payroll_action_id,'LEGAL_EMPLOYER'))