Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies extra information types for Eligibility Rate Profiles |
Implementation/DBA Data: | APPS.BENBV_ELP_INFO_TYPES_V |
SELECT ELP.INFORMATION_TYPE
, ELP.DESCRIPTION
, ELP.LEGISLATION_CODE
, ELP.PROGRAM_UPDATE_DATE
, ELP.ACTIVE_INACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.ACTIVE_INACTIVE_FLAG)
, ELP.MULTIPLE_OCCURENCES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELP.MULTIPLE_OCCURENCES_FLAG)
, /* ID COLUMNS */ ELP.REQUEST_ID
, ELP.PROGRAM_APPLICATION_ID
, ELP.PROGRAM_ID
, /* WHO COLUMNS */ ELP.LAST_UPDATE_DATE
, ELP.LAST_UPDATED_BY
, ELP.CREATED_BY
, ELP.CREATION_DATE
FROM BEN_ELP_INFO_TYPES ELP WITH READ ONLY