DBA Data[Home] [Help]

APPS.PER_NL_LTSR_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 497: FROM hr_all_organization_units hou1

493: AND hou.organization_id = c_org_id
494: AND EXISTS
495: (
496: SELECT 1
497: FROM hr_all_organization_units hou1
498: ,hr_organization_information hoi1
499: WHERE hou1.business_group_id = c_bg_id
500: AND hoi1.org_information_context = 'NL_LE_TAX_DETAILS'
501: AND hoi1.org_information1 IS NOT NULL

Line 507: FROM hr_all_organization_units hou2

503: AND hou1.organization_id = hoi1.organization_id
504: AND hou1.organization_id = hou.organization_id
505: UNION
506: SELECT 1
507: FROM hr_all_organization_units hou2
508: ,hr_organization_information hoi2
509: WHERE hou2.business_group_id = c_bg_id
510: AND hoi2.org_information_context = 'NL_ORG_INFORMATION'
511: AND hoi2.org_information4 IS NOT NULL