SELECT paei.rowid row_id, paei.assignment_id assignment_id, paei.aei_information1 shares_not_exercised, paei.aei_information2 date_granted from per_assignment_extra_info paei WHERE paei.information_type = 'HR_SHARES_INFO_HK'
SELECT PAEI.ROWID ROW_ID
, PAEI.ASSIGNMENT_ID ASSIGNMENT_ID
, PAEI.AEI_INFORMATION1 SHARES_NOT_EXERCISED
, PAEI.AEI_INFORMATION2 DATE_GRANTED
FROM PER_ASSIGNMENT_EXTRA_INFO PAEI
WHERE PAEI.INFORMATION_TYPE = 'HR_SHARES_INFO_HK'
|
|
|