SELECT paei.rowid row_id, paei.assignment_id assignment_id, paei.aei_information1 overseas_name, paei.aei_information2 overseas_address, decode(paei.aei_information4, 'KNOWN', to_char(trunc(to_number(paei.aei_information3))), paei.aei_information4) overseas_amount_message, paei.aei_information5 tax_reporting_year from per_assignment_extra_info paei WHERE paei.information_type = 'HR_OVERSEAS_CONCERN_HK'
SELECT PAEI.ROWID ROW_ID
, PAEI.ASSIGNMENT_ID ASSIGNMENT_ID
, PAEI.AEI_INFORMATION1 OVERSEAS_NAME
, PAEI.AEI_INFORMATION2 OVERSEAS_ADDRESS
, DECODE(PAEI.AEI_INFORMATION4
, 'KNOWN'
, TO_CHAR(TRUNC(TO_NUMBER(PAEI.AEI_INFORMATION3)))
, PAEI.AEI_INFORMATION4) OVERSEAS_AMOUNT_MESSAGE
, PAEI.AEI_INFORMATION5 TAX_REPORTING_YEAR
FROM PER_ASSIGNMENT_EXTRA_INFO PAEI
WHERE PAEI.INFORMATION_TYPE = 'HR_OVERSEAS_CONCERN_HK'
|
|
|