View: PAY_HK_IR56_QUARTERS_INFO_V

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

View Text

SELECT PAEI.ROWID ROW_ID
, PAEI.ASSIGNMENT_ID ASSIGNMENT_ID
, PHIQA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PHIQA.ACTION_SEQUENCE ACTION_SEQUENCE
, PHIQA.LEGAL_EMPLOYER_ID LEGAL_EMPLOYER_ID
, PHIQA.L_SOURCE_ID SOURCE_ID
, PAEI.AEI_INFORMATION1 QUARTERS_ADDRESS
, PAEI.AEI_INFORMATION2 QUARTERS_NATURE
, TO_CHAR( PAY_HK_IR56.GET_QUARTERS_START_DATE(PAA.ASSIGNMENT_ID
, PHIQA.L_SOURCE_ID)
, 'DD/MM/YYYY') QUARTERS_PERIOD_START
, TO_CHAR(PHIQA.END_DATE
, 'DD/MM/YYYY') QUARTERS_PERIOD_END
, PAY_BALANCE_PKG.GET_VALUE( PAY_HK_SOE_PKG.GET_BALANCE_ID('IR56_Q_ER_TO_LANDLORD'
, '_ASG_SRCE_YTD')
, PHIQA.ASSIGNMENT_ACTION_ID
, PHIQA.LEGAL_EMPLOYER_ID
, NULL
, PHIQA.L_SOURCE_ID
, NULL
, NULL) QUARTERS_ER_TO_LANDLORD
, PAY_BALANCE_PKG.GET_VALUE( PAY_HK_SOE_PKG.GET_BALANCE_ID('IR56_Q_EE_TO_LANDLORD'
, '_ASG_SRCE_YTD')
, PHIQA.ASSIGNMENT_ACTION_ID
, PHIQA.LEGAL_EMPLOYER_ID
, NULL
, PHIQA.L_SOURCE_ID
, NULL
, NULL) QUARTERS_EE_TO_LANDLORD
, PAY_BALANCE_PKG.GET_VALUE( PAY_HK_SOE_PKG.GET_BALANCE_ID('IR56_Q_REFUNDS_TO_EE'
, '_ASG_SRCE_YTD')
, PHIQA.ASSIGNMENT_ACTION_ID
, PHIQA.LEGAL_EMPLOYER_ID
, NULL
, PHIQA.L_SOURCE_ID
, NULL
, NULL) QUARTERS_REFUNDS_TO_EE
, PAY_BALANCE_PKG.GET_VALUE( PAY_HK_SOE_PKG.GET_BALANCE_ID('IR56_Q_EE_TO_ER'
, '_ASG_SRCE_YTD')
, PHIQA.ASSIGNMENT_ACTION_ID
, PHIQA.LEGAL_EMPLOYER_ID
, NULL
, PHIQA.L_SOURCE_ID
, NULL
, NULL) QUARTERS_EE_TO_ER
, PTP.START_DATE
, PTP.END_DATE
FROM PER_ASSIGNMENT_EXTRA_INFO PAEI
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PER_TIME_PERIODS PTP
, PAY_HK_IR56_QUARTERS_ACTIONS_V PHIQA
WHERE PHIQA.ASSIGNMENT_EXTRA_INFO_ID = PAEI.ASSIGNMENT_EXTRA_INFO_ID
AND PAEI.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PHIQA.ACTION_SEQUENCE = PAA.ACTION_SEQUENCE
AND PHIQA.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND PPA.PAYROLL_ID = PTP.PAYROLL_ID

Columns