Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PRTT_PREM_D |
SELECT PPE.ROWID ROW_ID
, PPE.PRTT_PREM_ID
, PPE.EFFECTIVE_START_DATE
, PPE.EFFECTIVE_END_DATE
, STD_PREM.NAME STD_PREM_MEANING
, PPE.STD_PREM_VAL
, ACTL_PREM.NAME ACTL_PREM_NAME
, PL.NAME PRTT_ENRT_RSLT_PLAN
, OPT.NAME PRTT_ENRT_RSLT_OIPL
, PPE.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
, PPE.PROGRAM_UPDATE_DATE
FROM BEN_PRTT_PREM_F PPE
, BEN_PER_IN_LER PIL
, FND_USER_VIEW FUSER
, BEN_ACTL_PREM_F ACTL_PREM
, BEN_PRTT_ENRT_RSLT_F PRTT_ENRT_RSLT
, FND_CURRENCIES_VL STD_PREM
, BEN_PL_F PL
, BEN_OIPL_F OIPL
, BEN_OPT_F OPT
WHERE FUSER.USER_ID(+)= PPE.LAST_UPDATED_BY
AND ACTL_PREM.ACTL_PREM_ID (+)= PPE.ACTL_PREM_ID
AND PRTT_ENRT_RSLT.PRTT_ENRT_RSLT_ID (+)= PPE.PRTT_ENRT_RSLT_ID
AND PL.PL_ID(+) = PRTT_ENRT_RSLT.PL_ID
AND OIPL.OIPL_ID(+) = PRTT_ENRT_RSLT.OIPL_ID
AND OPT.OPT_ID(+) = OIPL.OPT_ID
AND STD_PREM.CURRENCY_CODE (+)= PPE.STD_PREM_UOM
AND PIL.PER_IN_LER_ID=PPE.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID=PPE.BUSINESS_GROUP_ID