DBA Data[Home] [Help]

VIEW: APPS.PAY_HK_SHARES_V

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'