View: PAY_JP_TAX_SWOT_V

Product:	PAY - Payroll
Description:	This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_TAX_SWOT_V

View Text

SELECT PJWA.BUSINESS_GROUP_ID
, TO_NUMBER(TO_CHAR(PJWA.EFFECTIVE_DATE
, 'YYYY')) YEAR
, PJWA.ITAX_ORGANIZATION_ID
, PJWA.EFFECTIVE_DATE
, PJWA.DATE_EARNED
, PJWA.ASSIGNMENT_ACTION_ID
, PJWA.PERSON_ID
, PJWA.PERIOD_OF_SERVICE_ID
, PJWA.ITAX_CATEGORY
, PJWA.ITAX_YEA_CATEGORY
, DECODE(PADR.ADDRESS_ID
, NULL
, PADC.TOWN_OR_CITY
, PADR.TOWN_OR_CITY)
, PJWA.ACTUAL_TERMINATION_DATE
, PAY_JP_WIC_PKG.SPR_TERM_VALID( PJWA.ASSIGNMENT_ACTION_ID
, PJWA.ASSIGNMENT_ID
, PJWA.ACTION_SEQUENCE
, PJWA.EFFECTIVE_DATE
, PJWA.ITAX_ORGANIZATION_ID
, PJWA.ITAX_CATEGORY
, PJWA.ITAX_YEA_CATEGORY
, PJWA.EMPLOYMENT_CATEGORY
, PJWA.ACTUAL_TERMINATION_DATE)
FROM PER_ADDRESSES PADC
, PER_ADDRESSES PADR
, PAY_JP_WIC_ASSACTS_V PJWA
WHERE /* RESIDENTIAL ADDRESS */ PADR.PERSON_ID(+) = PJWA.PERSON_ID
AND PADR.ADDRESS_TYPE(+) = 'JP_R'
AND NVL(PJWA.ACTUAL_TERMINATION_DATE
, TO_DATE(LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(PJWA.EFFECTIVE_DATE
, 'YYYY'))+1)
, 4
, '0') || '-01-01'
, 'YYYY-MM-DD')) BETWEEN PADR.DATE_FROM(+)
AND NVL(PADR.DATE_TO(+)
, TO_DATE('4712-12-31'
, 'YYYY-MM-DD')) /* CURRENT ADDRESS */
AND PADC.PERSON_ID(+) = PJWA.PERSON_ID
AND PADC.ADDRESS_TYPE(+) = 'JP_C'
AND NVL(PJWA.ACTUAL_TERMINATION_DATE
, TO_DATE(LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(PJWA.EFFECTIVE_DATE
, 'YYYY'))+1)
, 4
, '0') || '-01-01'
, 'YYYY-MM-DD')) BETWEEN PADC.DATE_FROM(+)
AND NVL(PADC.DATE_TO(+)
, TO_DATE('4712-12-31'
, 'YYYY-MM-DD'))

Columns