Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies those communications which must be provided to persons who have been linked to a communication trigger with one of the sets of usages defined here. |
Implementation/DBA Data: | APPS.BENBV_CM_TYP_USG_V |
SELECT CTU.EFFECTIVE_START_DATE
, CTU.EFFECTIVE_END_DATE
, CTU.CM_USG_RL
, CTU.DESCR_TEXT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CM_TYP_USG_F:CTU'
, /* CODES */ CTU.ALL_R_ANY_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ALL_R_ANY'
, CTU.ALL_R_ANY_CD)
, /* ID COLUMNS */ CTU.CM_TYP_USG_ID
, CTU.BUSINESS_GROUP_ID
, CTU.CM_TYP_ID
, CTU.ENRT_PERD_ID
, CTU.ACTN_TYP_ID
, CTU.LER_ID
, CTU.PGM_ID
, CTU.PL_ID
, CTU.PL_TYP_ID
, /* WHO COLUMNS */ CTU.LAST_UPDATE_DATE
, CTU.LAST_UPDATED_BY
, CTU.CREATED_BY
, CTU.CREATION_DATE
FROM BEN_CM_TYP_USG_F CTU
WHERE CTU.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CTU.BUSINESS_GROUP_ID) WITH READ ONLY