SELECT PIT.INFORMATION_TYPE, PIT.DESCRIPTION, PIT.LEGISLATION_CODE, PIT.ACTIVE_INACTIVE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PIT.ACTIVE_INACTIVE_FLAG), PIT.MULTIPLE_OCCURENCES_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PIT.MULTIPLE_OCCURENCES_FLAG), PIT.LAST_UPDATE_DATE, PIT.LAST_UPDATED_BY, PIT.CREATED_BY, PIT.CREATION_DATE FROM PER_PEOPLE_INFO_TYPES PIT WITH READ ONLY
SELECT PIT.INFORMATION_TYPE
, PIT.DESCRIPTION
, PIT.LEGISLATION_CODE
, PIT.ACTIVE_INACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PIT.ACTIVE_INACTIVE_FLAG)
, PIT.MULTIPLE_OCCURENCES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PIT.MULTIPLE_OCCURENCES_FLAG)
, PIT.LAST_UPDATE_DATE
, PIT.LAST_UPDATED_BY
, PIT.CREATED_BY
, PIT.CREATION_DATE
FROM PER_PEOPLE_INFO_TYPES PIT WITH READ ONLY
|
|
|