VIEW: APPS.BEN_PRTT_PREM_D

Source

View Text - Preformatted

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 AND ppe.effective_start_date BETWEEN NVL (actl_prem.effective_start_date, ppe.effective_start_date ) AND NVL (actl_prem.effective_end_date, ppe.effective_end_date ) AND ppe.effective_start_date BETWEEN NVL (prtt_enrt_rslt.effective_start_date, ppe.effective_start_date ) AND NVL (prtt_enrt_rslt.effective_end_date, ppe.effective_end_date ) AND ppe.effective_start_date BETWEEN NVL (pl.effective_start_date, ppe.effective_start_date ) AND NVL (pl.effective_end_date, ppe.effective_end_date ) AND ppe.effective_start_date BETWEEN NVL (oipl.effective_start_date, ppe.effective_start_date ) AND NVL (oipl.effective_end_date, ppe.effective_end_date ) AND ppe.effective_start_date BETWEEN NVL (opt.effective_start_date, ppe.effective_start_date ) AND NVL (opt.effective_end_date, ppe.effective_end_date )

View Text - HTML Formatted

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
AND PPE.EFFECTIVE_START_DATE BETWEEN NVL (ACTL_PREM.EFFECTIVE_START_DATE
, PPE.EFFECTIVE_START_DATE )
AND NVL (ACTL_PREM.EFFECTIVE_END_DATE
, PPE.EFFECTIVE_END_DATE )
AND PPE.EFFECTIVE_START_DATE BETWEEN NVL (PRTT_ENRT_RSLT.EFFECTIVE_START_DATE
, PPE.EFFECTIVE_START_DATE )
AND NVL (PRTT_ENRT_RSLT.EFFECTIVE_END_DATE
, PPE.EFFECTIVE_END_DATE )
AND PPE.EFFECTIVE_START_DATE BETWEEN NVL (PL.EFFECTIVE_START_DATE
, PPE.EFFECTIVE_START_DATE )
AND NVL (PL.EFFECTIVE_END_DATE
, PPE.EFFECTIVE_END_DATE )
AND PPE.EFFECTIVE_START_DATE BETWEEN NVL (OIPL.EFFECTIVE_START_DATE
, PPE.EFFECTIVE_START_DATE )
AND NVL (OIPL.EFFECTIVE_END_DATE
, PPE.EFFECTIVE_END_DATE )
AND PPE.EFFECTIVE_START_DATE BETWEEN NVL (OPT.EFFECTIVE_START_DATE
, PPE.EFFECTIVE_START_DATE )
AND NVL (OPT.EFFECTIVE_END_DATE
, PPE.EFFECTIVE_END_DATE )