View: HRI_CL_PTY_NONPTU_B_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.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