Product: | BEN - Advanced Benefits |
---|---|
Description: | This folder identifies compensation alternatives, typically in coverage and investment choices, which are provided by one or more plans. |
Implementation/DBA Data: | APPS.BENBV_OPT_V |
SELECT OPT.EFFECTIVE_START_DATE
, OPT.EFFECTIVE_END_DATE
, OPT.NAME
, OPT.RQD_PERD_ENRT_NENRT_RL
, OPT.RQD_PERD_ENRT_NENRT_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RQD_PERD_ENRT_NENRT_TM_UOM'
, OPT.RQD_PERD_ENRT_NENRT_UOM)
, OPT.RQD_PERD_ENRT_NENRT_VAL
, OPT.SHORT_CODE
, OPT.SHORT_NAME
, OPT.COMPONENT_REASON
, HR_BIS.BIS_DECODE_LOOKUP('PROPOSAL_REASON'
, OPT.COMPONENT_REASON)
, OPT.MAPPING_TABLE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MAPPING_OPTION_TABLE'
, OPT.MAPPING_TABLE_NAME)
, OPT.LEGISLATION_CODE
, OPT.LEGISLATION_SUBGROUP
, BEN_BIS_UTILS.GET_GROUP_OPT_NAME(OPT.GROUP_OPT_ID
, OPT.EFFECTIVE_START_DATE)
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_OPT_F:OPT'
, OPT.INVK_WV_OPT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, OPT.INVK_WV_OPT_FLAG)
, /* ID COLUMNS */ OPT.OPT_ID
, OPT.BUSINESS_GROUP_ID
, OPT.CMBN_PTIP_OPT_ID
, OPT.MAPPING_TABLE_PK_ID
, OPT.GROUP_OPT_ID
, /* WHO COLUMNS */ OPT.LAST_UPDATE_DATE
, OPT.LAST_UPDATED_BY
, OPT.CREATED_BY
, OPT.CREATION_DATE
FROM BEN_OPT_F OPT
WHERE OPT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, OPT.BUSINESS_GROUP_ID) WITH READ ONLY