View: HR_PERSON_LEGISLATION_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.HR_PERSON_LEGISLATION_V

View Text

SELECT PAPF.PERSON_ID
, HOI.ORG_INFORMATION9
FROM PER_ALL_PEOPLE_F PAPF
, HR_ORGANIZATION_INFORMATION HOI
WHERE TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND PAPF.BUSINESS_GROUP_ID = HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION' UNION SELECT -1
, HOI.ORG_INFORMATION9
FROM HR_ORGANIZATION_INFORMATION HOI
WHERE HOI.ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION'

Columns