VIEW: APPS.BENBV_PRTT_ENRT_ACTN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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