Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PGM |
SELECT PGM.PGM_ID
, PGM.EFFECTIVE_START_DATE
, PGM.EFFECTIVE_END_DATE
, PGM.NAME
, PGM.DPNT_ADRS_RQD_FLAG
, PGM.PGM_PRVDS_NO_AUTO_ENRT_FLAG
, PGM.DPNT_DOB_RQD_FLAG
, PGM.PGM_PRVDS_NO_DFLT_ENRT_FLAG
, PGM.DPNT_LEGV_ID_RQD_FLAG
, PGM.DPNT_DSGN_LVL_CD
, PGM.PGM_STAT_CD
, PGM.IVR_IDENT
, PGM.PGM_TYP_CD
, PGM.ELIG_APLS_FLAG
, PGM.USES_ALL_ASMTS_FOR_RTS_FLAG
, PGM.URL_REF_NAME
, PGM.PGM_DESC
, PGM.PRTN_ELIG_OVRID_ALWD_FLAG
, PGM.PGM_USE_ALL_ASNTS_ELIG_FLAG
, PGM.DPNT_DSGN_CD
, PGM.MX_DPNT_PCT_PRTT_LF_AMT
, PGM.MX_SPS_PCT_PRTT_LF_AMT
, PGM.ACTY_REF_PERD_CD
, PGM.COORD_CVG_FOR_ALL_PLS_FLG
, PGM.ENRT_CVG_END_DT_CD
, PGM.ENRT_CVG_END_DT_RL
, PGM.DPNT_CVG_END_DT_CD
, PGM.DPNT_CVG_END_DT_RL
, PGM.DPNT_CVG_STRT_DT_CD
, PGM.DPNT_CVG_STRT_DT_RL
, PGM.DPNT_DSGN_NO_CTFN_RQD_FLAG
, PGM.DRVBL_FCTR_DPNT_ELIG_FLAG
, PGM.DRVBL_FCTR_PRTN_ELIG_FLAG
, PGM.ENRT_CVG_STRT_DT_CD
, PGM.ENRT_CVG_STRT_DT_RL
, PGM.ENRT_INFO_RT_FREQ_CD
, PGM.RT_STRT_DT_CD
, PGM.RT_STRT_DT_RL
, PGM.RT_END_DT_CD
, PGM.RT_END_DT_RL
, PGM.PGM_GRP_CD
, PGM.PGM_UOM
, PGM.DRVBL_FCTR_APLS_RTS_FLAG
, PGM.TRK_INELIG_PER_FLAG
, PGM.ALWS_UNRSTRCTD_ENRT_FLAG
, PGM.AUTO_ENRT_MTHD_RL
, PGM.ENRT_CD
, PGM.ENRT_MTHD_CD
, PGM.POE_LVL_CD
, PGM.ENRT_RL
, PGM.BUSINESS_GROUP_ID
, PGM.PGM_ATTRIBUTE_CATEGORY
, PGM.PGM_ATTRIBUTE1
, PGM.PGM_ATTRIBUTE2
, PGM.PGM_ATTRIBUTE3
, PGM.PGM_ATTRIBUTE4
, PGM.PGM_ATTRIBUTE5
, PGM.PGM_ATTRIBUTE6
, PGM.PGM_ATTRIBUTE7
, PGM.PGM_ATTRIBUTE8
, PGM.PGM_ATTRIBUTE9
, PGM.PGM_ATTRIBUTE10
, PGM.PGM_ATTRIBUTE11
, PGM.PGM_ATTRIBUTE12
, PGM.PGM_ATTRIBUTE13
, PGM.PGM_ATTRIBUTE14
, PGM.PGM_ATTRIBUTE15
, PGM.PGM_ATTRIBUTE16
, PGM.PGM_ATTRIBUTE17
, PGM.PGM_ATTRIBUTE18
, PGM.PGM_ATTRIBUTE19
, PGM.PGM_ATTRIBUTE20
, PGM.PGM_ATTRIBUTE21
, PGM.PGM_ATTRIBUTE22
, PGM.PGM_ATTRIBUTE23
, PGM.PGM_ATTRIBUTE24
, PGM.PGM_ATTRIBUTE25
, PGM.PGM_ATTRIBUTE26
, PGM.PGM_ATTRIBUTE27
, PGM.PGM_ATTRIBUTE28
, PGM.PGM_ATTRIBUTE29
, PGM.PGM_ATTRIBUTE30
, PGM.LAST_UPDATE_DATE
, PGM.LAST_UPDATED_BY
, PGM.LAST_UPDATE_LOGIN
, PGM.CREATED_BY
, PGM.CREATION_DATE
, PGM.OBJECT_VERSION_NUMBER
, PGM.VRFY_FMLY_MMBR_CD
, PGM.VRFY_FMLY_MMBR_RL
, PGM.PER_CVRD_CD
, PGM.SHORT_NAME
, PGM.SHORT_CODE
, PGM.DFLT_PGM_FLAG
, PGM.USE_PROG_POINTS_FLAG
, PGM.DFLT_STEP_CD
, PGM.DFLT_STEP_RL
, PGM.UPDATE_SALARY_CD
, PGM.USE_MULTI_PAY_RATES_FLAG
, PGM.DFLT_ELEMENT_TYPE_ID
, PGM.DFLT_INPUT_VALUE_ID
, PGM.USE_SCORES_CD
, PGM.SCORES_CALC_MTHD_CD
, PGM.SCORES_CALC_RL
, PGM.GSP_ALLOW_OVERRIDE_FLAG
, PGM.USE_VARIABLE_RATES_FLAG
, PGM.SALARY_CALC_MTHD_CD
, PGM.SALARY_CALC_MTHD_RL
, PGM.LEGISLATION_CODE
, PGM.LEGISLATION_SUBGROUP
FROM BEN_PGM_F PGM
WHERE PGM.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PGM.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))