VIEW: APPS.HRFV_PERSON_SPECIAL_INFO

Source

View Text - Preformatted

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

View Text - HTML Formatted

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