View: HRFV_PERSON_SPECIAL_INFO

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

View Text

SELECT DISTINCT BGRT.NAME BUSINESS_GROUP_NAME
, PER.FULL_NAME PERSON_NAME
, JR.DATE_FROM START_DATE
, JR.DATE_TO END_DATE
, FS1.ID_FLEX_STRUCTURE_NAME INFORMATION_TYPE
, '_DF:PER:PER_PERSON_ANALYSES:JR'
, JR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, FS1.ID_FLEX_NUM ID_FLEX_NUM
, JR.PERSON_ID PERSON_ID
FROM PER_ANALYSIS_CRITERIA AC
, PER_PERSON_ANALYSES JR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, FND_ID_FLEX_STRUCTURES_VL FS1
, PER_PEOPLE_X PER
WHERE AC.ANALYSIS_CRITERIA_ID = JR.ANALYSIS_CRITERIA_ID
AND PER.PERSON_ID = JR.PERSON_ID
AND AC.ID_FLEX_NUM = ( SELECT DISTINCT FS1.ID_FLEX_NUM
FROM PER_SPECIAL_INFO_TYPES SI
WHERE SI.ID_FLEX_NUM = FS1.ID_FLEX_NUM
AND AC.ID_FLEX_NUM = FS1.ID_FLEX_NUM
AND SI.ENABLED_FLAG = 'Y'
AND FS1.APPLICATION_ID = 800
AND FS1.ID_FLEX_CODE = 'PEA' )
AND JR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND JR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, JR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns