View: HRFV_PERSONAL_REHIRE_INFO

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.REHIRE_REASON REHIRE_REASON
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.REHIRE_RECOMMENDATION) REHIRE_RECOMMENDATION
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
WHERE PEO.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY

Columns