View: BENBV_ELIG_MLTRY_STAT_PRTE_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BENBV_ELIG_MLTRY_STAT_PRTE_V

View Text

SELECT EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ORDR_NUM
, /* CODES */ MLTRY_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, MLTRY_STAT_CD)
, EXCLD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EXCLD_FLAG)
, /* ID COLUMNS */ ELIG_MLTRY_STAT_PRTE_ID
, ELIGY_PRFL_ID
FROM BEN_ELIG_MLTRY_STAT_PRTE_F ELI WITH READ ONLY

Columns