VIEW: APPS.HRBV_PERSON_TYPE

Source

View Text - Preformatted

SELECT ppt.seeded_person_type_key seeded_person_type_key ,hr_bis.bis_decode_lookup('YES_NO',ppt.active_flag) active_flag ,hr_bis.bis_decode_lookup('YES_NO',ppt.default_flag) default_flag ,hr_bis.bis_decode_lookup('PERSON_TYPE',ppt.system_person_type) system_person_type ,pptT.user_person_type user_person_type ,ppt.active_flag active_flag_code ,ppt.default_flag default_flag_code ,hr_api.return_legislation_code(ppt.business_group_id) legislation_code ,ppt.person_type_id person_type_id ,ppt.business_group_id business_group_id ,ppt.last_update_date last_update_date ,ppt.last_updated_by last_updated_by ,ppt.last_update_login last_update_login ,ppt.created_by created_by ,ppt.creation_date creation_date ,CASE WHEN (ppt.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, ppt.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_person_types ppt ,per_person_types_tl pptT WHERE ppt.person_type_id = pptT.person_type_id AND pptT.language = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT PPT.SEEDED_PERSON_TYPE_KEY SEEDED_PERSON_TYPE_KEY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PPT.ACTIVE_FLAG) ACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PPT.DEFAULT_FLAG) DEFAULT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('PERSON_TYPE'
, PPT.SYSTEM_PERSON_TYPE) SYSTEM_PERSON_TYPE
, PPTT.USER_PERSON_TYPE USER_PERSON_TYPE
, PPT.ACTIVE_FLAG ACTIVE_FLAG_CODE
, PPT.DEFAULT_FLAG DEFAULT_FLAG_CODE
, HR_API.RETURN_LEGISLATION_CODE(PPT.BUSINESS_GROUP_ID) LEGISLATION_CODE
, PPT.PERSON_TYPE_ID PERSON_TYPE_ID
, PPT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PPT.LAST_UPDATED_BY LAST_UPDATED_BY
, PPT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PPT.CREATED_BY CREATED_BY
, PPT.CREATION_DATE CREATION_DATE
, CASE WHEN (PPT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPT.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_PERSON_TYPES PPT
, PER_PERSON_TYPES_TL PPTT
WHERE PPT.PERSON_TYPE_ID = PPTT.PERSON_TYPE_ID
AND PPTT.LANGUAGE = USERENV('LANG') WITH READ ONLY