VIEW: APPS.BEN_PL_TYP_D

Source

View Text - Preformatted

SELECT PTP.ROWID ROW_ID , PTP.PL_TYP_ID , PTP.EFFECTIVE_START_DATE , PTP.EFFECTIVE_END_DATE , PTP.NAME , PTP.MX_ENRL_ALWD_NUM , PTP.MN_ENRL_RQD_NUM , PL_TYP_STAT.MEANING , PTP.ivr_ident , NO_MX_ENRL_NUM_DFND.MEANING , NO_MN_ENRL_NUM_DFND.MEANING , OPT_TYP.MEANING , PTP.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY , OPT_DSPLY_FMT.MEANING , COMP_TYP.MEANING , PTP.SHORT_NAME , PTP.SHORT_CODE , PTP.LEGISLATION_CODE , PTP.LEGISLATION_SUBGROUP FROM BEN_PL_TYP_F PTP, FND_USER FUSER ,HR_LOOKUPS PL_TYP_STAT ,HR_LOOKUPS OPT_TYP ,HR_LOOKUPS NO_MX_ENRL_NUM_DFND ,HR_LOOKUPS NO_MN_ENRL_NUM_DFND ,HR_LOOKUPS OPT_DSPLY_FMT ,HR_LOOKUPS COMP_TYP WHERE FUSER.USER_ID (+)= PTP.LAST_UPDATED_BY AND PL_TYP_STAT.LOOKUP_CODE (+)= PTP.PL_TYP_STAT_CD AND PL_TYP_STAT.LOOKUP_TYPE (+)= 'BEN_STAT' AND OPT_TYP.LOOKUP_CODE (+)= PTP.OPT_TYP_CD AND OPT_TYP.LOOKUP_TYPE (+)= 'BEN_OPT_TYP' AND NO_MX_ENRL_NUM_DFND.LOOKUP_CODE (+)= PTP.NO_MX_ENRL_NUM_DFND_FLAG AND NO_MX_ENRL_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO' AND NO_MN_ENRL_NUM_DFND.LOOKUP_CODE (+)= PTP.NO_MN_ENRL_NUM_DFND_FLAG AND NO_MN_ENRL_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO' AND OPT_DSPLY_FMT.LOOKUP_CODE (+) = PTP.OPT_DSPLY_FMT_CD AND OPT_DSPLY_FMT.LOOKUP_TYPE (+) = 'BEN_OPT_DSPLY_FMT' AND COMP_TYP.LOOKUP_CODE (+) = PTP.COMP_TYP_CD AND COMP_TYP.LOOKUP_TYPE (+) = 'BEN_COMP_TYP'

View Text - HTML Formatted

SELECT PTP.ROWID ROW_ID
, PTP.PL_TYP_ID
, PTP.EFFECTIVE_START_DATE
, PTP.EFFECTIVE_END_DATE
, PTP.NAME
, PTP.MX_ENRL_ALWD_NUM
, PTP.MN_ENRL_RQD_NUM
, PL_TYP_STAT.MEANING
, PTP.IVR_IDENT
, NO_MX_ENRL_NUM_DFND.MEANING
, NO_MN_ENRL_NUM_DFND.MEANING
, OPT_TYP.MEANING
, PTP.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
, OPT_DSPLY_FMT.MEANING
, COMP_TYP.MEANING
, PTP.SHORT_NAME
, PTP.SHORT_CODE
, PTP.LEGISLATION_CODE
, PTP.LEGISLATION_SUBGROUP
FROM BEN_PL_TYP_F PTP
, FND_USER FUSER
, HR_LOOKUPS PL_TYP_STAT
, HR_LOOKUPS OPT_TYP
, HR_LOOKUPS NO_MX_ENRL_NUM_DFND
, HR_LOOKUPS NO_MN_ENRL_NUM_DFND
, HR_LOOKUPS OPT_DSPLY_FMT
, HR_LOOKUPS COMP_TYP
WHERE FUSER.USER_ID (+)= PTP.LAST_UPDATED_BY
AND PL_TYP_STAT.LOOKUP_CODE (+)= PTP.PL_TYP_STAT_CD
AND PL_TYP_STAT.LOOKUP_TYPE (+)= 'BEN_STAT'
AND OPT_TYP.LOOKUP_CODE (+)= PTP.OPT_TYP_CD
AND OPT_TYP.LOOKUP_TYPE (+)= 'BEN_OPT_TYP'
AND NO_MX_ENRL_NUM_DFND.LOOKUP_CODE (+)= PTP.NO_MX_ENRL_NUM_DFND_FLAG
AND NO_MX_ENRL_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MN_ENRL_NUM_DFND.LOOKUP_CODE (+)= PTP.NO_MN_ENRL_NUM_DFND_FLAG
AND NO_MN_ENRL_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND OPT_DSPLY_FMT.LOOKUP_CODE (+) = PTP.OPT_DSPLY_FMT_CD
AND OPT_DSPLY_FMT.LOOKUP_TYPE (+) = 'BEN_OPT_DSPLY_FMT'
AND COMP_TYP.LOOKUP_CODE (+) = PTP.COMP_TYP_CD
AND COMP_TYP.LOOKUP_TYPE (+) = 'BEN_COMP_TYP'