View: BEN_POPL_ORG_ROLE_D

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_POPL_ORG_ROLE_D

View Text

SELECT CPR.ROWID ROW_ID
, CPR.POPL_ORG_ROLE_ID
, CPR.EFFECTIVE_START_DATE
, CPR.EFFECTIVE_END_DATE
, CPR.NAME
, POPL_ORG.CSTMR_NUM
, POPL_ORG.PLCY_R_GRP
, CPR.LAST_UPDATE_DATE
, FUSER.USER_NAME
, ROLE_TYP.MEANING
FROM BEN_POPL_ORG_ROLE_F CPR
, FND_USER_VIEW FUSER
, BEN_POPL_ORG_F POPL_ORG
, HR_LOOKUPS ROLE_TYP
WHERE FUSER.USER_ID (+)= CPR.LAST_UPDATED_BY
AND POPL_ORG.POPL_ORG_ID (+)= CPR.POPL_ORG_ID
AND ROLE_TYP.LOOKUP_CODE (+)= CPR.ORG_ROLE_TYP_CD
AND ROLE_TYP.LOOKUP_TYPE (+)= 'BEN_ORG_ROLE_TYP'

Columns