View: BENBV_PER_IN_LER_V

Product:	BEN - Advanced Benefits
Description:	This view identifies all life events for a person, including identifying which life event, if any, is currently in progress for the specified person.
Implementation/DBA Data:	APPS.BENBV_PER_IN_LER_V

View Text

SELECT PIL.LF_EVT_OCRD_DT
, PIL.PROGRAM_UPDATE_DATE
, PIL.PROCD_DT
, PIL.STRTD_DT
, PIL.VOIDD_DT
, PIL.BCKT_DT
, PIL.CLSD_DT
, PIL.NTFN_DT
, PIL.MGR_OVRID_DT
, BEN_BIS_UTILS.GET_GROUP_PL_NAME(PIL.GROUP_PL_ID
, PIL.LF_EVT_OCRD_DT)
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_IN_LER:PIL'
, /* CODES */ PIL.PER_IN_LER_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT'
, PIL.PER_IN_LER_STAT_CD)
, PIL.PRVS_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT'
, PIL.PRVS_STAT_CD)
, /* ID COLUMNS */ PIL.PER_IN_LER_ID
, PIL.BUSINESS_GROUP_ID
, PIL.LER_ID
, PIL.PERSON_ID
, PIL.PTNL_LER_FOR_PER_ID
, PIL.REQUEST_ID
, PIL.PROGRAM_APPLICATION_ID
, PIL.PROGRAM_ID
, PIL.BCKT_PER_IN_LER_ID
, PIL.TRGR_TABLE_PK_ID
, PIL.ASSIGNMENT_ID
, PIL.WS_MGR_ID
, PIL.GROUP_PL_ID
, PIL.MGR_OVRID_PERSON_ID
, /* WHO COLUMNS */ PIL.LAST_UPDATE_DATE
, PIL.LAST_UPDATED_BY
, PIL.CREATED_BY
, PIL.CREATION_DATE
FROM BEN_PER_IN_LER PIL
WHERE PIL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PIL.BUSINESS_GROUP_ID) WITH READ ONLY

Columns