494: AND hou.organization_id = c_org_id
495: AND EXISTS
496: (
497: SELECT 1
498: FROM hr_all_organization_units hou1
499: ,hr_organization_information hoi1
500: WHERE hou1.business_group_id = c_bg_id
501: AND hoi1.org_information_context = 'NL_LE_TAX_DETAILS'
502: AND hoi1.org_information1 IS NOT NULL
504: AND hou1.organization_id = hoi1.organization_id
505: AND hou1.organization_id = hou.organization_id
506: UNION
507: SELECT 1
508: FROM hr_all_organization_units hou2
509: ,hr_organization_information hoi2
510: WHERE hou2.business_group_id = c_bg_id
511: AND hoi2.org_information_context = 'NL_ORG_INFORMATION'
512: AND hoi2.org_information4 IS NOT NULL