[Home] [Help]
View: BEN_CWB_EQUITY_EDGE_OPT_INFO_V
View Text
SELECT PER2.EMPLOYEE_NUMBER
, BT.ATTRIBUTE2 OPTION_NUMBER
, BT.ATTRIBUTE3 PLAN_NAME
, BT.ATTRIBUTE4 TYPE
, BT.ATTRIBUTE5 CLASS
, BT.ATTRIBUTE6 OPTION_DATE
, BT.ATTRIBUTE7 GRANT_DATE_MARKET_VALUE
, BT.ATTRIBUTE8 PRICE
, PRT.RT_VAL SHARES
, BT.ATTRIBUTE9 MAX_SAR_PCT
, BT.ATTRIBUTE10 VEST_TEMPLATE
, BT.ATTRIBUTE11 VEST_BASE_DATE
, 'Y' ACTIVE_FLAG
, BT.TRANSACTION_ID
, POPL.ENRT_PERD_ID
FROM BEN_PIL_ELCTBL_CHC_POPL POPL
, BEN_PER_IN_LER PIL
, BEN_ELIG_PER_ELCTBL_CHC CHC2
, BEN_ENRT_RT ENR
, BEN_PRTT_RT_VAL PRT
, PER_ALL_PEOPLE_F PER2
, BEN_TRANSACTION BT
WHERE CHC2.ELIG_PER_ELCTBL_CHC_ID = ENR.ELIG_PER_ELCTBL_CHC_ID
AND ENR.ACTY_TYP_CD = 'CWBWS'
AND ENR.PRTT_RT_VAL_ID = PRT.PRTT_RT_VAL_ID (+)
AND PRT.RT_VAL > 0
AND CHC2.PER_IN_LER_ID = PIL.PER_IN_LER_ID
AND CHC2.ELIG_FLAG = 'Y'
AND CHC2.ELCTBL_FLAG = 'Y'
AND PIL.PER_IN_LER_STAT_CD IN ('STRTD'
, 'PROCD')
AND PIL.PERSON_ID = PER2.PERSON_ID
AND SYSDATE BETWEEN PER2.EFFECTIVE_START_DATE
AND PER2.EFFECTIVE_END_DATE
AND PIL.PER_IN_LER_ID = POPL.PER_IN_LER_ID
AND BT.TRANSACTION_TYPE = 'CWB_WEBADI' ORDER BY PER2.PERSON_ID
Columns
Name |
EMPLOYEE_NUMBER |
OPTION_NUMBER |
PLAN_NAME |
TYPE |
CLASS |
OPTION_DATE |
GRANT_DATE_MARKET_VALUE |
PRICE |
SHARES |
MAX_SAR_PCT |
VEST_TEMPLATE |
VEST_BASE_DATE |
ACTIVE_FLAG |
TRANSACTION_ID |
ENRT_PERD_ID |