VIEW: APPS.BENBV_YR_PERD_V

Source

View Text - Preformatted

SELECT YRP.END_DATE, YRP.START_DATE, YRP.LMTN_YR_STRT_DT, YRP.LMTN_YR_END_DT, YRP.PERDS_IN_YR_NUM, /* descriptive flexfield */ '_DF:BEN:BEN_YR_PERD:YRP', /* codes */ YRP.PERD_TM_UOM_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',YRP.PERD_TM_UOM_CD), YRP.PERD_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PERD_TYP',YRP.PERD_TYP_CD), /* id columns */ YRP.YR_PERD_ID, YRP.BUSINESS_GROUP_ID, /* who columns */ YRP.LAST_UPDATE_DATE, YRP.LAST_UPDATED_BY, YRP.CREATED_BY, YRP.CREATION_DATE FROM BEN_YR_PERD YRP WHERE YRP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, YRP.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT YRP.END_DATE
, YRP.START_DATE
, YRP.LMTN_YR_STRT_DT
, YRP.LMTN_YR_END_DT
, YRP.PERDS_IN_YR_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_YR_PERD:YRP'
, /* CODES */ YRP.PERD_TM_UOM_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, YRP.PERD_TM_UOM_CD)
, YRP.PERD_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PERD_TYP'
, YRP.PERD_TYP_CD)
, /* ID COLUMNS */ YRP.YR_PERD_ID
, YRP.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ YRP.LAST_UPDATE_DATE
, YRP.LAST_UPDATED_BY
, YRP.CREATED_BY
, YRP.CREATION_DATE
FROM BEN_YR_PERD YRP
WHERE YRP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, YRP.BUSINESS_GROUP_ID) WITH READ ONLY