DBA Data[Home] [Help]

VIEW: APPS.HRBV_PREV_JOB_INFO_TYPES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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