Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PGM_D |
SELECT PGM.ROWID ROW_ID
, PGM.PGM_ID
, PGM.EFFECTIVE_START_DATE
, PGM.EFFECTIVE_END_DATE
, PGM.NAME
, DPNT_ADRS_RQD.MEANING
, PGM_PRVDS_NO_AUTO_ENRT.MEANING
, DPNT_DOB_RQD.MEANING
, PGM_PRVDS_NO_DFLT_ENRT.MEANING
, DPNT_LEGV_ID_RQD.MEANING
, DPNT_DSGN_LVL.MEANING
, PGM_STAT.MEANING
, PGM.IVR_IDENT
, PGM_TYP.MEANING
, ELIG_APLS.MEANING
, PGM.URL_REF_NAME
, PGM.PGM_DESC
, DPNT_DSGN.MEANING
, PGM.MX_DPNT_PCT_PRTT_LF_AMT
, PGM.MX_SPS_PCT_PRTT_LF_AMT
, ACTY_REF_PERD.MEANING
, PGM.COORD_CVG_FOR_ALL_PLS_FLG
, PGM.LAST_UPDATE_DATE
, FUSER.USER_NAME
, PGM.SHORT_NAME
, PGM.SHORT_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PGM.DFLT_PGM_FLAG)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PGM.USE_PROG_POINTS_FLAG)
, HR_GENERAL.DECODE_LOOKUP('BEN_DFLT_STEP'
, PGM.DFLT_STEP_CD)
, PGM.DFLT_STEP_RL
, HR_GENERAL.DECODE_LOOKUP('BEN_UPDATE_SALARY'
, PGM.UPDATE_SALARY_CD)
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PGM.USE_MULTI_PAY_RATES_FLAG)
, PGM.DFLT_ELEMENT_TYPE_ID
, PGM.DFLT_INPUT_VALUE_ID
, HR_GENERAL.DECODE_LOOKUP('BEN_USE_SCORES'
, PGM.USE_SCORES_CD )
, HR_GENERAL.DECODE_LOOKUP('BEN_SCORES_CALC_MTHD'
, PGM.SCORES_CALC_MTHD_CD )
, PGM.SCORES_CALC_RL
FROM BEN_PGM_F PGM
, FND_USER FUSER
, HR_LOOKUPS DPNT_LEGV_ID_RQD
, HR_LOOKUPS DPNT_DSGN_LVL
, HR_LOOKUPS PGM_STAT
, HR_LOOKUPS PGM_TYP
, HR_LOOKUPS DPNT_DSGN
, HR_LOOKUPS ACTY_REF_PERD
, HR_LOOKUPS DPNT_ADRS_RQD
, HR_LOOKUPS PGM_PRVDS_NO_AUTO_ENRT
, HR_LOOKUPS DPNT_DOB_RQD
, HR_LOOKUPS PGM_PRVDS_NO_DFLT_ENRT
, HR_LOOKUPS ELIG_APLS
WHERE FUSER.USER_ID (+)= PGM.LAST_UPDATED_BY
AND DPNT_LEGV_ID_RQD.LOOKUP_CODE (+)= PGM.DPNT_LEGV_ID_RQD_FLAG
AND DPNT_LEGV_ID_RQD.LOOKUP_TYPE (+)= 'YES_NO'
AND DPNT_DSGN_LVL.LOOKUP_CODE (+)= PGM.DPNT_DSGN_LVL_CD
AND DPNT_DSGN_LVL.LOOKUP_TYPE (+)= 'BEN_DPNT_DSGN_LVL'
AND PGM_STAT.LOOKUP_CODE (+)= PGM.PGM_STAT_CD
AND PGM_STAT.LOOKUP_TYPE (+)= 'BEN_STAT'
AND PGM_TYP.LOOKUP_CODE (+)= PGM.PGM_TYP_CD
AND PGM_TYP.LOOKUP_TYPE (+)= 'BEN_PGM_TYP'
AND DPNT_DSGN.LOOKUP_CODE (+)= PGM.DPNT_DSGN_CD
AND DPNT_DSGN.LOOKUP_TYPE (+)= 'BEN_DPNT_DSGN'
AND ACTY_REF_PERD.LOOKUP_CODE (+)= PGM.ACTY_REF_PERD_CD
AND ACTY_REF_PERD.LOOKUP_TYPE (+)= 'BEN_ACTY_REF_PERD'
AND DPNT_ADRS_RQD.LOOKUP_CODE (+)= PGM.DPNT_ADRS_RQD_FLAG
AND DPNT_ADRS_RQD.LOOKUP_TYPE (+)= 'YES_NO'
AND PGM_PRVDS_NO_AUTO_ENRT.LOOKUP_CODE (+)= PGM.PGM_PRVDS_NO_AUTO_ENRT_FLAG
AND PGM_PRVDS_NO_AUTO_ENRT.LOOKUP_TYPE (+)= 'YES_NO'
AND DPNT_DOB_RQD.LOOKUP_CODE (+)= PGM.DPNT_DOB_RQD_FLAG
AND DPNT_DOB_RQD.LOOKUP_TYPE (+)= 'YES_NO'
AND PGM_PRVDS_NO_DFLT_ENRT.LOOKUP_CODE (+)= PGM.PGM_PRVDS_NO_DFLT_ENRT_FLAG
AND PGM_PRVDS_NO_DFLT_ENRT.LOOKUP_TYPE (+)= 'YES_NO'
AND ELIG_APLS.LOOKUP_CODE (+)= PGM.ELIG_APLS_FLAG
AND ELIG_APLS.LOOKUP_TYPE (+)= 'YES_NO'