Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies any outstanding enrollment action items required of a person in order for elections or life events to be unsuspended or, at a minimum, considered complete. |
Implementation/DBA Data: | APPS.BENBV_PRTT_ENRT_ACTN_V |
SELECT PEA.EFFECTIVE_START_DATE
, PEA.EFFECTIVE_END_DATE
, PEA.PROGRAM_UPDATE_DATE
, PEA.CMPLTD_DT
, PEA.DUE_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRTT_ENRT_ACTN_F:PEA'
, PEA.RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEA.RQD_FLAG)
, /* ID COLUMNS */ PEA.PRTT_ENRT_ACTN_ID
, PEA.ACTN_TYP_ID
, PEA.PRTT_ENRT_RSLT_ID
, PEA.PER_IN_LER_ID
, PEA.BUSINESS_GROUP_ID
, PEA.REQUEST_ID
, PEA.PROGRAM_APPLICATION_ID
, PEA.PROGRAM_ID
, PEA.PL_BNF_ID
, PEA.ELIG_CVRD_DPNT_ID
, /* WHO COLUMNS */ PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PEA.CREATED_BY
, PEA.CREATION_DATE
FROM BEN_PRTT_ENRT_ACTN_F PEA
WHERE PEA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEA.BUSINESS_GROUP_ID) WITH READ ONLY