VIEW: APPS.BENBV_PL_GD_OR_SVC_V

Source

View Text - Preformatted

SELECT VGS.EFFECTIVE_START_DATE, VGS.EFFECTIVE_END_DATE, VGS.GD_SVC_RECD_BASIS_DT, VGS.GD_SVC_RECD_BASIS_MO, /* descriptive flexfield */ '_DF:BEN:BEN_PL_GD_OR_SVC_F:VGS', /* codes */ VGS.GD_OR_SVC_USG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_GD_OR_SVC_USG',VGS.GD_OR_SVC_USG_CD), VGS.GD_SVC_RECD_BASIS_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_GD_SVC_RECD_BASIS',VGS.GD_SVC_RECD_BASIS_CD), VGS.ALW_RCRRG_CLMS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',VGS.ALW_RCRRG_CLMS_FLAG), /* id columns */ VGS.PL_GD_OR_SVC_ID, VGS.BUSINESS_GROUP_ID, VGS.GD_OR_SVC_TYP_ID, VGS.PL_ID, /* who columns */ VGS.LAST_UPDATE_DATE, VGS.LAST_UPDATED_BY, VGS.CREATED_BY, VGS.CREATION_DATE FROM BEN_PL_GD_OR_SVC_F VGS WHERE VGS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, VGS.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT VGS.EFFECTIVE_START_DATE
, VGS.EFFECTIVE_END_DATE
, VGS.GD_SVC_RECD_BASIS_DT
, VGS.GD_SVC_RECD_BASIS_MO
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PL_GD_OR_SVC_F:VGS'
, /* CODES */ VGS.GD_OR_SVC_USG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_GD_OR_SVC_USG'
, VGS.GD_OR_SVC_USG_CD)
, VGS.GD_SVC_RECD_BASIS_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_GD_SVC_RECD_BASIS'
, VGS.GD_SVC_RECD_BASIS_CD)
, VGS.ALW_RCRRG_CLMS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, VGS.ALW_RCRRG_CLMS_FLAG)
, /* ID COLUMNS */ VGS.PL_GD_OR_SVC_ID
, VGS.BUSINESS_GROUP_ID
, VGS.GD_OR_SVC_TYP_ID
, VGS.PL_ID
, /* WHO COLUMNS */ VGS.LAST_UPDATE_DATE
, VGS.LAST_UPDATED_BY
, VGS.CREATED_BY
, VGS.CREATION_DATE
FROM BEN_PL_GD_OR_SVC_F VGS
WHERE VGS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, VGS.BUSINESS_GROUP_ID) WITH READ ONLY