VIEW: APPS.BEN_PGM_V

Source

View Text - Preformatted

SELECT PGM.ROWID ROW_ID , 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.susp_if_dpnt_ssn_nt_prv_cd, pgm.susp_if_dpnt_dob_nt_prv_cd, pgm.susp_if_dpnt_adr_nt_prv_cd, pgm.susp_if_ctfn_not_dpnt_flag, pgm.dpnt_ctfn_determine_cd, 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, PGM.ALL_INELIG FROM BEN_PGM_F PGM, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN PGM.EFFECTIVE_START_DATE AND PGM.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PGM.ROWID ROW_ID
, 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.SUSP_IF_DPNT_SSN_NT_PRV_CD
, PGM.SUSP_IF_DPNT_DOB_NT_PRV_CD
, PGM.SUSP_IF_DPNT_ADR_NT_PRV_CD
, PGM.SUSP_IF_CTFN_NOT_DPNT_FLAG
, PGM.DPNT_CTFN_DETERMINE_CD
, 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
, PGM.ALL_INELIG
FROM BEN_PGM_F PGM
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PGM.EFFECTIVE_START_DATE
AND PGM.EFFECTIVE_END_DATE