[Home] [Help]
View: BENBV_PL_INFO_TYPES_V
Product: | BEN - Advanced Benefits |
Description: | This view identifies extra information types for Plans |
Implementation/DBA Data: |
APPS.BENBV_PL_INFO_TYPES_V
|
View Text
SELECT PL.INFORMATION_TYPE
, PL.DESCRIPTION
, PL.LEGISLATION_CODE
, PL.PROGRAM_UPDATE_DATE
, PL.ACTIVE_INACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PL.ACTIVE_INACTIVE_FLAG)
, PL.MULTIPLE_OCCURENCES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PL.MULTIPLE_OCCURENCES_FLAG)
, /* ID COLUMNS */ PL.REQUEST_ID
, PL.PROGRAM_APPLICATION_ID
, PL.PROGRAM_ID
, /* WHO COLUMNS */ PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.CREATED_BY
, PL.CREATION_DATE
FROM BEN_PL_INFO_TYPES PL WITH READ ONLY
Columns
Name |
INFORMATION_TYPE |
DESCRIPTION |
LEGISLATION_CODE |
PROGRAM_UPDATE_DATE |
ACTIVE_INACTIVE_FLAG |
ACTIVE_INACTIVE_FLAG_M |
MULTIPLE_OCCURENCES_FLAG |
MULTIPLE_OCCURENCES_FLAG_M |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |