VIEW: APPS.BEN_CWB_STOCK_HIST_DWLD_V

Source

View Text - Preformatted

SELECT mgr_pil.group_pl_id, mgr_pil.lf_evt_ocrd_dt, mgr_pil.person_id mgr_person_id, fnd_message.get_string('BEN','BEN_93757_CWB_GRANT_TEXT') || ' ' ||stock.grant_date grant_name, ( DECODE ('BN', 'BN', info.brief_name, 'CN', info.custom_name, info.full_name ) || ' - ' || info.employee_number ) employee_name, stock.grant_shares shares_granted, grant_price grant_price, vested_shares shares_vested, unvested_shares shares_unvested, (CASE WHEN fnd_profile.value('BEN_CWB_ESTIMATED_MKT_PRICE') < grant_price THEN 0 ELSE unvested_shares * (fnd_profile.value('BEN_CWB_ESTIMATED_MKT_PRICE') - grant_price) END) walk_away, info.person_id person_id FROM ben_per_in_ler mgr_pil, ben_cwb_stock_optn_dtls stock, ben_cwb_person_info info, ben_cwb_group_hrchy hrchy WHERE hrchy.mgr_per_in_ler_id = mgr_pil.per_in_ler_id AND hrchy.lvl_num BETWEEN 1 AND 9999 AND info.group_per_in_ler_id = hrchy.emp_per_in_ler_id AND stock.person_id = info.person_id AND mgr_pil.per_in_ler_stat_cd <> 'BCKDT'

View Text - HTML Formatted

SELECT MGR_PIL.GROUP_PL_ID
, MGR_PIL.LF_EVT_OCRD_DT
, MGR_PIL.PERSON_ID MGR_PERSON_ID
, FND_MESSAGE.GET_STRING('BEN'
, 'BEN_93757_CWB_GRANT_TEXT') || ' ' ||STOCK.GRANT_DATE GRANT_NAME
, ( DECODE ('BN'
, 'BN'
, INFO.BRIEF_NAME
, 'CN'
, INFO.CUSTOM_NAME
, INFO.FULL_NAME ) || ' - ' || INFO.EMPLOYEE_NUMBER ) EMPLOYEE_NAME
, STOCK.GRANT_SHARES SHARES_GRANTED
, GRANT_PRICE GRANT_PRICE
, VESTED_SHARES SHARES_VESTED
, UNVESTED_SHARES SHARES_UNVESTED
, (CASE WHEN FND_PROFILE.VALUE('BEN_CWB_ESTIMATED_MKT_PRICE') < GRANT_PRICE THEN 0 ELSE UNVESTED_SHARES * (FND_PROFILE.VALUE('BEN_CWB_ESTIMATED_MKT_PRICE') - GRANT_PRICE) END) WALK_AWAY
, INFO.PERSON_ID PERSON_ID
FROM BEN_PER_IN_LER MGR_PIL
, BEN_CWB_STOCK_OPTN_DTLS STOCK
, BEN_CWB_PERSON_INFO INFO
, BEN_CWB_GROUP_HRCHY HRCHY
WHERE HRCHY.MGR_PER_IN_LER_ID = MGR_PIL.PER_IN_LER_ID
AND HRCHY.LVL_NUM BETWEEN 1
AND 9999
AND INFO.GROUP_PER_IN_LER_ID = HRCHY.EMP_PER_IN_LER_ID
AND STOCK.PERSON_ID = INFO.PERSON_ID
AND MGR_PIL.PER_IN_LER_STAT_CD <> 'BCKDT'