Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies extra information for Eligibility Rate Profiles |
Implementation/DBA Data: | APPS.BENBV_ELP_EXTRA_INFO_V |
SELECT ELI.INFORMATION_TYPE
, ELI.PROGRAM_UPDATE_DATE
, /* DEVELOPER FLEXFIELD */ '_DF:BEN:ELIGIBILITY PROFILE INFO DDF:ELI'
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:ELIGIBILITY PROFILE INFO:ELI'
, /* ID COLUMNS */ ELI.ELP_EXTRA_INFO_ID
, ELI.ELIGY_PRFL_ID
, ELI.REQUEST_ID
, ELI.PROGRAM_APPLICATION_ID
, ELI.PROGRAM_ID
, /* WHO COLUMNS */ ELI.LAST_UPDATE_DATE
, ELI.LAST_UPDATED_BY
, ELI.CREATED_BY
, ELI.CREATION_DATE
FROM BEN_ELP_EXTRA_INFO ELI WITH READ ONLY