DBA Data[Home] [Help]

APPS.PER_NL_LTSRR_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 498: FROM hr_all_organization_units hou1

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

Line 508: FROM hr_all_organization_units hou2

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