VIEW: APPS.BEN_PGM_D

Source

View Text - Preformatted

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 , 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'

View Text - HTML Formatted

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
, 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'