Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PL_TYP_D |
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'