DBA Data[Home] [Help]

APPS.PER_NL_WAZO_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 499: FROM hr_all_organization_units hou1

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

Line 509: FROM hr_all_organization_units hou2

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