VIEW: APPS.BEN_PL_TYP_OPT_TYP_D

Source

View Text - Preformatted

SELECT pon.ROWID ROW_ID, pon.PL_TYP_OPT_TYP_ID , pon.EFFECTIVE_START_DATE ,pon.EFFECTIVE_END_DATE , PL_TYP_OPT_TYP.MEANING ,OPT.NAME ,PL_TYP.NAME , pon.LAST_UPDATE_DATE ,fuser.user_name ,pon.LEGISLATION_CODE ,pon.LEGISLATION_SUBGROUP FROM BEN_PL_TYP_OPT_TYP_F pon, fnd_user_view fuser , BEN_OPT_F OPT ,BEN_PL_TYP_F PL_TYP ,hr_lookups PL_TYP_OPT_TYP WHERE fuser.user_id (+)= pon .last_updated_by AND OPT.OPT_ID (+)= pon .OPT_ID AND PL_TYP.PL_TYP_ID (+)= pon .PL_TYP_ID AND PL_TYP_OPT_TYP.lookup_code (+)= pon .PL_TYP_OPT_TYP_CD AND PL_TYP_OPT_TYP.lookup_type (+)= 'BEN_OPT_TYP' AND pon.effective_start_date between opt.effective_start_date(+) and opt.effective_start_date(+) AND pon.effective_start_date between pl_typ.effective_start_date(+) and pl_typ.effective_start_date(+)

View Text - HTML Formatted

SELECT PON.ROWID ROW_ID
, PON.PL_TYP_OPT_TYP_ID
, PON.EFFECTIVE_START_DATE
, PON.EFFECTIVE_END_DATE
, PL_TYP_OPT_TYP.MEANING
, OPT.NAME
, PL_TYP.NAME
, PON.LAST_UPDATE_DATE
, FUSER.USER_NAME
, PON.LEGISLATION_CODE
, PON.LEGISLATION_SUBGROUP
FROM BEN_PL_TYP_OPT_TYP_F PON
, FND_USER_VIEW FUSER
, BEN_OPT_F OPT
, BEN_PL_TYP_F PL_TYP
, HR_LOOKUPS PL_TYP_OPT_TYP
WHERE FUSER.USER_ID (+)= PON .LAST_UPDATED_BY
AND OPT.OPT_ID (+)= PON .OPT_ID
AND PL_TYP.PL_TYP_ID (+)= PON .PL_TYP_ID
AND PL_TYP_OPT_TYP.LOOKUP_CODE (+)= PON .PL_TYP_OPT_TYP_CD
AND PL_TYP_OPT_TYP.LOOKUP_TYPE (+)= 'BEN_OPT_TYP'
AND PON.EFFECTIVE_START_DATE BETWEEN OPT.EFFECTIVE_START_DATE(+)
AND OPT.EFFECTIVE_START_DATE(+)
AND PON.EFFECTIVE_START_DATE BETWEEN PL_TYP.EFFECTIVE_START_DATE(+)
AND PL_TYP.EFFECTIVE_START_DATE(+)