eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BEN_CWB_EQUITY_EDGE_OPT_INFO_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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