View: PAY_HK_IR56_OVERSEAS_CONCERN_V

Product:	PAY - Payroll
Description:	Hong Kong localisation view.
Implementation/DBA Data:	APPS.PAY_HK_IR56_OVERSEAS_CONCERN_V

View Text

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'

Columns