DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_CWB_STOCK_OPTN_DTLS

Line 921: ben_cwb_stock_optn_dtls

917: p_emp_num IN VARCHAR2 )
918: IS
919: SELECT sum(current_shares_outstanding) total
920: FROM
921: ben_cwb_stock_optn_dtls
922: WHERE ( person_id = v_person_id
923: OR (business_group_id = v_business_group
924: AND employee_number = p_emp_num) )
925: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd