VIEW: APPS.BEN_PL_REGY_PRP_D

Source

View Text - Preformatted

SELECT prp.ROWID ROW_ID, prp.PL_REGY_PRPS_ID ,prp.EFFECTIVE_START_DATE ,prp.EFFECTIVE_END_DATE ,PL_REGY_PRPS.MEANING ,PL_REGY_BOD.REGY_PL_NAME ,prp.LAST_UPDATE_DATE ,fuser.user_name from BEN_PL_REGY_PRP_F prp, fnd_user_view fuser ,BEN_PL_REGY_BOD_F PL_REGY_BOD ,hr_lookups PL_REGY_PRPS WHERE fuser.user_id(+) = prp.last_updated_by AND pl_regy_bod.pl_regy_bod_id(+) = prp.pl_regy_bod_id AND pl_regy_prps.lookup_code(+) = prp.pl_regy_prps_cd AND pl_regy_prps.lookup_type(+) = 'BEN_REGY_PRPS' AND prp.effective_start_date BETWEEN pl_regy_bod.effective_start_date(+) AND pl_regy_bod.effective_end_date(+)

View Text - HTML Formatted

SELECT PRP.ROWID ROW_ID
, PRP.PL_REGY_PRPS_ID
, PRP.EFFECTIVE_START_DATE
, PRP.EFFECTIVE_END_DATE
, PL_REGY_PRPS.MEANING
, PL_REGY_BOD.REGY_PL_NAME
, PRP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PL_REGY_PRP_F PRP
, FND_USER_VIEW FUSER
, BEN_PL_REGY_BOD_F PL_REGY_BOD
, HR_LOOKUPS PL_REGY_PRPS
WHERE FUSER.USER_ID(+) = PRP.LAST_UPDATED_BY
AND PL_REGY_BOD.PL_REGY_BOD_ID(+) = PRP.PL_REGY_BOD_ID
AND PL_REGY_PRPS.LOOKUP_CODE(+) = PRP.PL_REGY_PRPS_CD
AND PL_REGY_PRPS.LOOKUP_TYPE(+) = 'BEN_REGY_PRPS'
AND PRP.EFFECTIVE_START_DATE BETWEEN PL_REGY_BOD.EFFECTIVE_START_DATE(+)
AND PL_REGY_BOD.EFFECTIVE_END_DATE(+)