SELECT INT.INFORMATION_TYPE, INT.DESCRIPTION, INT.LEGISLATION_CODE, INT.ACTIVE_INACTIVE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',INT.ACTIVE_INACTIVE_FLAG), INT.MULTIPLE_OCCURANCES_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',INT.MULTIPLE_OCCURANCES_FLAG), INT.LAST_UPDATE_DATE, INT.LAST_UPDATED_BY, INT.CREATED_BY, INT.CREATION_DATE FROM PER_PREV_JOB_INFO_TYPES INT WITH READ ONLY
SELECT INT.INFORMATION_TYPE
, INT.DESCRIPTION
, INT.LEGISLATION_CODE
, INT.ACTIVE_INACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, INT.ACTIVE_INACTIVE_FLAG)
, INT.MULTIPLE_OCCURANCES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, INT.MULTIPLE_OCCURANCES_FLAG)
, INT.LAST_UPDATE_DATE
, INT.LAST_UPDATED_BY
, INT.CREATED_BY
, INT.CREATION_DATE
FROM PER_PREV_JOB_INFO_TYPES INT WITH READ ONLY
|
|
|