VIEW: APPS.BEN_PPL_GRP_RT_D

Source

View Text - Preformatted

SELECT pgr.ROWID ROW_ID, pgr.PPL_GRP_RT_ID ,pgr.EFFECTIVE_START_DATE ,pgr.EFFECTIVE_END_DATE ,pgr.ORDR_NUM ,EXCLD.MEANING ,VRBL_RT_PRFL.NAME ,PEOPLE_GROUP.GROUP_NAME ,pgr.LAST_UPDATE_DATE ,fuser.LAST_UPDATED_BY from BEN_PPL_GRP_RT_F pgr, fnd_user fuser ,BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL ,PAY_PEOPLE_GROUPS PEOPLE_GROUP ,hr_lookups EXCLD WHERE fuser.user_id (+)= pgr .last_updated_by and VRBL_RT_PRFL.VRBL_RT_PRFL_ID (+)= pgr .VRBL_RT_PRFL_ID and PEOPLE_GROUP.PEOPLE_GROUP_ID (+)= pgr .PEOPLE_GROUP_ID and EXCLD.lookup_code (+)= pgr .EXCLD_FLAG and EXCLD.lookup_type (+)= 'YES_NO' AND pgr.effective_start_date between vrbl_rt_prfl.effective_start_date(+) and vrbl_rt_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT PGR.ROWID ROW_ID
, PGR.PPL_GRP_RT_ID
, PGR.EFFECTIVE_START_DATE
, PGR.EFFECTIVE_END_DATE
, PGR.ORDR_NUM
, EXCLD.MEANING
, VRBL_RT_PRFL.NAME
, PEOPLE_GROUP.GROUP_NAME
, PGR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_PPL_GRP_RT_F PGR
, FND_USER FUSER
, BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL
, PAY_PEOPLE_GROUPS PEOPLE_GROUP
, HR_LOOKUPS EXCLD
WHERE FUSER.USER_ID (+)= PGR .LAST_UPDATED_BY
AND VRBL_RT_PRFL.VRBL_RT_PRFL_ID (+)= PGR .VRBL_RT_PRFL_ID
AND PEOPLE_GROUP.PEOPLE_GROUP_ID (+)= PGR .PEOPLE_GROUP_ID
AND EXCLD.LOOKUP_CODE (+)= PGR .EXCLD_FLAG
AND EXCLD.LOOKUP_TYPE (+)= 'YES_NO'
AND PGR.EFFECTIVE_START_DATE BETWEEN VRBL_RT_PRFL.EFFECTIVE_START_DATE(+)
AND VRBL_RT_PRFL.EFFECTIVE_END_DATE(+)