View: HRFV_GB_PERSONAL_DETAILS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_GB_PERSONAL_DETAILS

View Text

SELECT BGR.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.PRE_NAME_ADJUNCT PREFIX
, PEO.SUFFIX SUFFIX
, PEO.FIRST_NAME FIRST_NAME
, PEO.LAST_NAME LAST_NAME
, PEO.KNOWN_AS PREFERRED_NAME
, PEO.MIDDLE_NAMES MIDDLE_NAMES
, PEO.TITLE TITLE
, PEO.NATIONAL_IDENTIFIER NI_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('ETH_TYPE'
, PEO.PER_INFORMATION1) ETHNIC_ORIGIN
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION2) DIRECTOR
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION4) PENSIONER
, PEO.PER_INFORMATION5 WORK_PERMIT_NUMBER
, TO_NUMBER(PEO.PER_INFORMATION6) ADDL_PENSIONABLE_YEARS
, TO_NUMBER(PEO.PER_INFORMATION7) ADDL_PENSIONABLE_MONTHS
, TO_NUMBER(PEO.PER_INFORMATION8) ADDL_PENSIONABLE_DAYS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION9) NI_MULTIPLE_ASSIGNMENTS
, '_DF:PER:PER_PEOPLE:PEO'
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
FROM PER_BUSINESS_GROUPS BGR
, PER_PEOPLE_X PEO
WHERE BGR.LEGISLATION_CODE = 'GB'
AND PEO.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY

Columns