VIEW: APPS.BEN_POPL_ORG_ROLE_D

Source

View Text - Preformatted

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' AND cpr.effective_start_date BETWEEN popl_org.effective_start_date(+) AND popl_org.effective_end_date(+)

View Text - HTML Formatted

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'
AND CPR.EFFECTIVE_START_DATE BETWEEN POPL_ORG.EFFECTIVE_START_DATE(+)
AND POPL_ORG.EFFECTIVE_END_DATE(+)