Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the potential life events that exists for a person. |
Implementation/DBA Data: | APPS.BENBV_PTNL_LER_FOR_PER_V |
SELECT PTN.LF_EVT_OCRD_DT
, PTN.DTCTD_DT
, PTN.PROCD_DT
, PTN.UNPROCD_DT
, PTN.VOIDD_DT
, PTN.MNL_DT
, PTN.MNLO_DT
, PTN.PROGRAM_UPDATE_DATE
, PTN.NTFN_DT
, /* CODES */ PTN.PTNL_LER_FOR_PER_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PTNL_LER_FOR_PER_STAT'
, PTN.PTNL_LER_FOR_PER_STAT_CD)
, PTN.PTNL_LER_FOR_PER_SRC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PTNL_LER_FOR_PER_SRC'
, PTN.PTNL_LER_FOR_PER_SRC_CD)
, /* ID COLUMNS */ PTN.PTNL_LER_FOR_PER_ID
, PTN.BUSINESS_GROUP_ID
, PTN.LER_ID
, PTN.PERSON_ID
, PTN.ENRT_PERD_ID
, PTN.REQUEST_ID
, PTN.PROGRAM_APPLICATION_ID
, PTN.PROGRAM_ID
, PTN.CSD_BY_PTNL_LER_FOR_PER_ID
, PTN.TRGR_TABLE_PK_ID
, /* WHO COLUMNS */ PTN.LAST_UPDATE_DATE
, PTN.LAST_UPDATED_BY
, PTN.CREATED_BY
, PTN.CREATION_DATE
FROM BEN_PTNL_LER_FOR_PER PTN
WHERE PTN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PTN.BUSINESS_GROUP_ID) WITH READ ONLY