Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the communications that must be provided to a person who has a life event in progress and the communications that have been requested by that person. |
Implementation/DBA Data: | APPS.BENBV_PER_CM_PRVDD_V |
SELECT PCD.EFFECTIVE_START_DATE
, PCD.EFFECTIVE_END_DATE
, PCD.PROGRAM_UPDATE_DATE
, PCD.SENT_DT
, PCD.INSTNC_NUM
, PCD.TO_BE_SENT_DT
, PCD.DLVRY_INSTN_TXT
, PCD.RESND_CMNT_TXT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_CM_PRVDD_F:PCD'
, /* CODES */ PCD.PER_CM_PRVDD_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_CM_PRVDD_STAT'
, PCD.PER_CM_PRVDD_STAT_CD)
, PCD.CM_DLVRY_MED_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MED'
, PCD.CM_DLVRY_MED_CD)
, PCD.CM_DLVRY_MTHD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MTHD'
, PCD.CM_DLVRY_MTHD_CD)
, PCD.RESND_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RESND_RSN'
, PCD.RESND_RSN_CD)
, PCD.RQSTD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCD.RQSTD_FLAG)
, PCD.INSPN_RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCD.INSPN_RQD_FLAG)
, /* ID COLUMNS */ PCD.PER_CM_PRVDD_ID
, PCD.PER_CM_ID
, PCD.BUSINESS_GROUP_ID
, PCD.REQUEST_ID
, PCD.PROGRAM_APPLICATION_ID
, PCD.PROGRAM_ID
, PCD.ADDRESS_ID
, /* WHO COLUMNS */ PCD.LAST_UPDATE_DATE
, PCD.LAST_UPDATED_BY
, PCD.CREATED_BY
, PCD.CREATION_DATE
FROM BEN_PER_CM_PRVDD_F PCD
WHERE PCD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCD.BUSINESS_GROUP_ID) WITH READ ONLY