View: BENBV_PER_CM_V

Product:	BEN - Advanced Benefits
Description:	This view identifies persons and communications that are created as the result of a communication trigger being fired for the applicable usage for the person.
Implementation/DBA Data:	APPS.BENBV_PER_CM_V

View Text

SELECT PCM.EFFECTIVE_START_DATE
, PCM.EFFECTIVE_END_DATE
, PCM.RQSTBL_UNTL_DT
, PCM.PROGRAM_UPDATE_DATE
, PCM.LF_EVT_OCRD_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_CM_F:PCM'
, /* ID COLUMNS */ PCM.PER_CM_ID
, PCM.PERSON_ID
, PCM.CM_TYP_ID
, PCM.BUSINESS_GROUP_ID
, PCM.REQUEST_ID
, PCM.PROGRAM_APPLICATION_ID
, PCM.PROGRAM_ID
, PCM.LER_ID
, PCM.BNF_PERSON_ID
, PCM.DPNT_PERSON_ID
, PCM.PRTT_ENRT_ACTN_ID
, PCM.PER_IN_LER_ID
, /* WHO COLUMNS */ PCM.LAST_UPDATE_DATE
, PCM.LAST_UPDATED_BY
, PCM.CREATED_BY
, PCM.CREATION_DATE
FROM BEN_PER_CM_F PCM
WHERE PCM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCM.BUSINESS_GROUP_ID) WITH READ ONLY

Columns