[Home] [Help]
View: HRI_CL_PTY_NONPTU_B_V
View Text
SELECT PPTT.USER_PERSON_TYPE
, PPT.DEFAULT_FLAG
, PPT.SYSTEM_PERSON_TYPE
, PPT.PERSON_TYPE_ID
, PPT.BUSINESS_GROUP_ID
FROM PER_PERSON_TYPES PPT
, PER_PERSON_TYPES_TL PPTT
WHERE PPT.PERSON_TYPE_ID = PPTT.PERSON_TYPE_ID
AND PPTT.LANGUAGE = USERENV('LANG')
AND PPT.ACTIVE_FLAG = 'Y'
AND PPT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPT.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
USER_PERSON_TYPE |
DEFAULT_FLAG |
SYSTEM_PERSON_TYPE |
PERSON_TYPE_ID |
BUSINESS_GROUP_ID |