View: BEN_CWB_STOCK_TOTAL_POS_DTL_V

Product:	BEN - Advanced Benefits
Description:	Total Stock Positions Detail.
Implementation/DBA Data:	APPS.BEN_CWB_STOCK_TOTAL_POS_DTL_V

View Text

SELECT PPF.EMPLOYEE_NUMBER
, PPF.FULL_NAME FULL_NAME
, PPF.FIRST_NAME || ' ' || PPF.LAST_NAME BRIEF_NAME
, GRANT_NUMBER
, GRANT_NAME
, GRANT_TYPE
, GRANT_DATE
, GRANT_SHARES
, GRANT_PRICE
, VALUE_AT_GRANT
, CURRENT_SHARE_PRICE
, CURRENT_SHARES_OUTSTANDING
, VESTED_SHARES
, UNVESTED_SHARES
, EXERCISABLE_SHARES
, EXERCISED_SHARES
, CANCELLED_SHARES
, TRADING_SYMBOL
, EXPIRATION_DATE
, REASON_CODE
, CLASS
, MISC
, PPF.PERSON_ID
, ASG.SUPERVISOR_ID
FROM BEN_CWB_STOCK_OPTN_DTLS CSO
, PER_ALL_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F ASG
WHERE PPF.PERSON_ID = ASG.PERSON_ID
AND ASG.PRIMARY_FLAG = 'Y'
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND ( PPF.PERSON_ID = CSO.PERSON_ID OR (PPF.BUSINESS_GROUP_ID = CSO.BUSINESS_GROUP_ID
AND PPF.EMPLOYEE_NUMBER = CSO.EMPLOYEE_NUMBER) ) ORDER BY PPF.FULL_NAME DESC
, GRANT_DATE

Columns