View: BENBV_OPT_INFO_TYPES_V

Product:	BEN - Advanced Benefits
Description:	This view identifies extra information types for Options
Implementation/DBA Data:	APPS.BENBV_OPT_INFO_TYPES_V

View Text

SELECT OPT.INFORMATION_TYPE
, OPT.DESCRIPTION
, OPT.LEGISLATION_CODE
, OPT.PROGRAM_UPDATE_DATE
, OPT.ACTIVE_INACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, OPT.ACTIVE_INACTIVE_FLAG)
, OPT.MULTIPLE_OCCURENCES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, OPT.MULTIPLE_OCCURENCES_FLAG)
, /* ID COLUMNS */ OPT.REQUEST_ID
, OPT.PROGRAM_APPLICATION_ID
, OPT.PROGRAM_ID
, /* WHO COLUMNS */ OPT.LAST_UPDATE_DATE
, OPT.LAST_UPDATED_BY
, OPT.CREATED_BY
, OPT.CREATION_DATE
FROM BEN_OPT_INFO_TYPES OPT WITH READ ONLY

Columns