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