DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 631: FROM hr_all_organization_units hou1

627: AND hou.organization_id = c_org_id
628: AND EXISTS
629: (
630: SELECT 1
631: FROM hr_all_organization_units hou1
632: ,hr_organization_information hoi1
633: WHERE hou1.business_group_id = c_bg_id
634: AND hoi1.org_information_context = 'NL_LE_TAX_DETAILS'
635: AND hoi1.org_information1 IS NOT NULL

Line 641: FROM hr_all_organization_units hou2

637: AND hou1.organization_id = hoi1.organization_id
638: AND hou1.organization_id = hou.organization_id
639: UNION
640: SELECT 1
641: FROM hr_all_organization_units hou2
642: ,hr_organization_information hoi2
643: WHERE hou2.business_group_id = c_bg_id
644: AND hoi2.org_information_context = 'NL_ORG_INFORMATION'
645: AND hoi2.org_information4 IS NOT NULL