APPS.PER_NL_DSR_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 632: ,hr_organization_information hoi1

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
636: AND hoi1.org_information2 IS NOT NULL

Line 642: ,hr_organization_information hoi2

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
646: AND hoi2.org_information3 IS NOT NULL

Line 665: ,hr_organization_information hoi1

661: AND EXISTS
662: (
663: SELECT 1
664: FROM hr_organization_units hou1
665: ,hr_organization_information hoi1
666: WHERE hoi1.org_information_context = 'NL_ORG_INFORMATION'
667: AND hou1.business_group_id = c_bg_id
668: AND hou1.organization_id = hou.organization_id
669: AND hou1.organization_id = hoi1.organization_id

Line 695: ,hr_organization_information hoi2

691: )
692: UNION
693: SELECT 1
694: FROM hr_organization_units hou2
695: ,hr_organization_information hoi2
696: WHERE hoi2.org_information_context = 'NL_LE_TAX_DETAILS'
697: AND hou2.business_group_id = c_bg_id
698: AND hou2.organization_id = hou.organization_id
699: AND hou2.organization_id = hoi2.organization_id

Line 1305: ,hr_organization_information hoi

1301: ,hou.name org_name
1302: ,hoi.org_information4 tax_reg
1303: FROM per_all_assignments_f pas
1304: ,hr_organization_units hou
1305: ,hr_organization_information hoi
1306: ,per_org_structure_versions posv
1307: WHERE posv.organization_structure_id = p_org_struct_id
1308: AND p_abs_start_date BETWEEN posv.date_from
1309: AND nvl (posv.date_to

Line 1323: ,hr_organization_information hoi

1319: ,hou.name org_name
1320: ,hoi.org_information1 tax_reg
1321: FROM per_all_assignments_f pas
1322: ,hr_organization_units hou
1323: ,hr_organization_information hoi
1324: WHERE pas.assignment_id = p_assignment_id
1325: AND hou.organization_id = pas.establishment_id
1326: AND hoi.organization_id = hou.organization_id
1327: AND hoi.org_information_context = 'NL_LE_TAX_DETAILS';

Line 1436: ,hr_organization_information hoi

1432: ,hoi.org_information8 gender_contact
1433: ,hoi.org_information9 ph_no_contact
1434: FROM per_all_assignments_f pas
1435: ,hr_organization_units hou
1436: ,hr_organization_information hoi
1437: WHERE pas.assignment_id = p_assignment_id
1438: AND p_start_date BETWEEN pas.effective_start_date
1439: AND pas.effective_end_date
1440: AND hou.organization_id = nvl (pas.establishment_id