VIEW: APPS.HRI_CL_PTY_USR_N_V

Source

View Text - Preformatted

SELECT ppt.person_type_id ID , ppttl.user_person_type VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , CASE WHEN ppt.system_person_type = 'EMP' THEN 'Y' ELSE 'N' END EMP_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type = 'EX_EMP' THEN 'Y' ELSE 'N' END EX_EMP_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type = 'APL' THEN 'Y' ELSE 'N' END APL_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type = 'EX_APL' THEN 'Y' ELSE 'N' END EX_APL_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type = 'CWK' THEN 'Y' ELSE 'N' END CWK_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type = 'EX_CWK' THEN 'Y' ELSE 'N' END EX_CWK_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type = 'OTHER' THEN 'Y' ELSE 'N' END OTHER_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type in ('EMP','APL') THEN 'Y' ELSE 'N' END EMP_APL_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type in ('CWK','APL') THEN 'Y' ELSE 'N' END CWK_APL_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type in ('EX_EMP','EX_APL') THEN 'Y' ELSE 'N' END EX_EMP_EX_APL_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type in ('EX_CWK','EX_APL') THEN 'Y' ELSE 'N' END EX_CWK_EX_APL_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type in ('EMP','CWK') THEN 'Y' ELSE 'N' END WRK_PTY_FLAG_CODE , CASE WHEN ppt.system_person_type in ('EX_EMP','EX_CWK') THEN 'Y' ELSE 'N' END EX_WRK_PTY_FLAG_CODE , ppt.system_person_type SYSTEM_PERSON_TYPE , ppt.active_flag ACTIVE_FLAG_CODE , ppt.business_group_id BUSINESS_GROUP_ID , 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 ppttl WHERE ppt.person_type_id = ppttl.person_type_id AND ppttl.language = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT PPT.PERSON_TYPE_ID ID
, PPTTL.USER_PERSON_TYPE VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE = 'EMP' THEN 'Y' ELSE 'N' END EMP_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE = 'EX_EMP' THEN 'Y' ELSE 'N' END EX_EMP_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE = 'APL' THEN 'Y' ELSE 'N' END APL_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE = 'EX_APL' THEN 'Y' ELSE 'N' END EX_APL_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE = 'CWK' THEN 'Y' ELSE 'N' END CWK_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE = 'EX_CWK' THEN 'Y' ELSE 'N' END EX_CWK_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE = 'OTHER' THEN 'Y' ELSE 'N' END OTHER_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE IN ('EMP'
, 'APL') THEN 'Y' ELSE 'N' END EMP_APL_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE IN ('CWK'
, 'APL') THEN 'Y' ELSE 'N' END CWK_APL_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE IN ('EX_EMP'
, 'EX_APL') THEN 'Y' ELSE 'N' END EX_EMP_EX_APL_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE IN ('EX_CWK'
, 'EX_APL') THEN 'Y' ELSE 'N' END EX_CWK_EX_APL_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE IN ('EMP'
, 'CWK') THEN 'Y' ELSE 'N' END WRK_PTY_FLAG_CODE
, CASE WHEN PPT.SYSTEM_PERSON_TYPE IN ('EX_EMP'
, 'EX_CWK') THEN 'Y' ELSE 'N' END EX_WRK_PTY_FLAG_CODE
, PPT.SYSTEM_PERSON_TYPE SYSTEM_PERSON_TYPE
, PPT.ACTIVE_FLAG ACTIVE_FLAG_CODE
, PPT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, 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 PPTTL
WHERE PPT.PERSON_TYPE_ID = PPTTL.PERSON_TYPE_ID
AND PPTTL.LANGUAGE = USERENV('LANG') WITH READ ONLY