VIEW: APPS.BENBV_OPT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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