VIEW: APPS.HR_LEG_ESTABLISHMENTS_V

Source

View Text - Preformatted

SELECT b.organization_id , tl.name , b.business_group_id , b.date_from , b.date_to ,bg.legislation_code FROM hr_organization_information hoi , hr_all_organization_units_tl tl , hr_all_organization_units b , per_business_groups_perf bg WHERE tl.organization_id = b.organization_id AND tl.language = userenv('LANG') AND hoi.organization_id = b.organization_id AND hoi.org_information_context = 'CLASS' AND hoi.org_information1 = decode( bg.legislation_code, 'FR','FR_ETABLISSEMENT', 'KR','KR_BUSINESS_PLACE', 'NL','HR_LEGAL_EMPLOYER', bg.legislation_code||'_ESTABLISHMENT') AND bg.business_group_id = b.business_group_id AND hoi.org_information2 = 'Y'

View Text - HTML Formatted

SELECT B.ORGANIZATION_ID
, TL.NAME
, B.BUSINESS_GROUP_ID
, B.DATE_FROM
, B.DATE_TO
, BG.LEGISLATION_CODE
FROM HR_ORGANIZATION_INFORMATION HOI
, HR_ALL_ORGANIZATION_UNITS_TL TL
, HR_ALL_ORGANIZATION_UNITS B
, PER_BUSINESS_GROUPS_PERF BG
WHERE TL.ORGANIZATION_ID = B.ORGANIZATION_ID
AND TL.LANGUAGE = USERENV('LANG')
AND HOI.ORGANIZATION_ID = B.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND HOI.ORG_INFORMATION1 = DECODE( BG.LEGISLATION_CODE
, 'FR'
, 'FR_ETABLISSEMENT'
, 'KR'
, 'KR_BUSINESS_PLACE'
, 'NL'
, 'HR_LEGAL_EMPLOYER'
, BG.LEGISLATION_CODE||'_ESTABLISHMENT')
AND BG.BUSINESS_GROUP_ID = B.BUSINESS_GROUP_ID
AND HOI.ORG_INFORMATION2 = 'Y'