Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the list of goods or services that may be reimbursed by the compensation plan. |
Implementation/DBA Data: | APPS.BENBV_PL_GD_OR_SVC_V |
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