VIEW: APPS.HRIFV_PEREIT

Source

View Text - Preformatted

SELECT per.full_name person_name , eif.information_type information_type , hr_bis.bis_decode_lookup('YES_NO', eit.active_inactive_flag) active_inactive , hr_bis.bis_decode_lookup('YES_NO', eit.multiple_occurences_flag) multiple_occurences , eit.description extra_info_type_description , eit.legislation_code legislation_code , per.effective_start_date person_effective_start_date , per.effective_end_date person_effective_end_date , '_DF:PER:Extra Person Info DDF:eif' , '_DF:PER:PER_PEOPLE_EXTRA_INFO:eif' , eit.active_inactive_flag active_inactive_flag , eit.multiple_occurences_flag multiple_occurences_flag , eif.person_extra_info_id person_extra_info_id , per.person_id person_id , per.business_group_id business_group_id FROM per_people_extra_info eif , per_people_info_types eit , per_people_f per WHERE eif.information_type = eit.information_type AND eif.person_id = per.person_id AND per.business_group_id = nvl(hr_bis.get_sec_profile_bg_id, per.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT PER.FULL_NAME PERSON_NAME
, EIF.INFORMATION_TYPE INFORMATION_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EIT.ACTIVE_INACTIVE_FLAG) ACTIVE_INACTIVE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EIT.MULTIPLE_OCCURENCES_FLAG) MULTIPLE_OCCURENCES
, EIT.DESCRIPTION EXTRA_INFO_TYPE_DESCRIPTION
, EIT.LEGISLATION_CODE LEGISLATION_CODE
, PER.EFFECTIVE_START_DATE PERSON_EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE PERSON_EFFECTIVE_END_DATE
, '_DF:PER:EXTRA PERSON INFO DDF:EIF'
, '_DF:PER:PER_PEOPLE_EXTRA_INFO:EIF'
, EIT.ACTIVE_INACTIVE_FLAG ACTIVE_INACTIVE_FLAG
, EIT.MULTIPLE_OCCURENCES_FLAG MULTIPLE_OCCURENCES_FLAG
, EIF.PERSON_EXTRA_INFO_ID PERSON_EXTRA_INFO_ID
, PER.PERSON_ID PERSON_ID
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_PEOPLE_EXTRA_INFO EIF
, PER_PEOPLE_INFO_TYPES EIT
, PER_PEOPLE_F PER
WHERE EIF.INFORMATION_TYPE = EIT.INFORMATION_TYPE
AND EIF.PERSON_ID = PER.PERSON_ID
AND PER.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PER.BUSINESS_GROUP_ID) WITH READ ONLY