Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BENBV_PGM_INFO_TYPES_V |
SELECT PGM.INFORMATION_TYPE
, PGM.DESCRIPTION
, PGM.LEGISLATION_CODE
, PGM.PROGRAM_UPDATE_DATE
, PGM.ACTIVE_INACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PGM.ACTIVE_INACTIVE_FLAG)
, PGM.MULTIPLE_OCCURENCES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PGM.MULTIPLE_OCCURENCES_FLAG)
, /* ID COLUMNS */ PGM.REQUEST_ID
, PGM.PROGRAM_APPLICATION_ID
, PGM.PROGRAM_ID
, /* WHO COLUMNS */ PGM.LAST_UPDATE_DATE
, PGM.LAST_UPDATED_BY
, PGM.CREATED_BY
, PGM.CREATION_DATE
FROM BEN_PGM_INFO_TYPES PGM WITH READ ONLY