View: PAY_JP_TAX_SWOT_WITHHELD_V

View Text

SELECT PPI.BUSINESS_GROUP_ID
, PPI.YEAR
, PPI.TAX_ORGANIZATION_ID
, PPI.EFFECTIVE_DATE
, PPI.DATE_EARNED
, PPI.ASSIGNMENT_ACTION_ID
, PPI.PERSON_ID
, PPI.PERIOD_OF_SERVICE_ID
, PPI.TAX_CATEGORY
, PPI.TAX_YEA_CATEGORY
, DECODE(PADR.ADDRESS_ID
, NULL
, PADC.TOWN_OR_CITY
, PADR.TOWN_OR_CITY)
FROM PER_ADDRESSES PADC
, PER_ADDRESSES PADR
, PAY_JP_TAX_SWOT_V PPI
WHERE /* RESIDENTIAL ADDRESS */ PADR.PERSON_ID(+) = PPI.PERSON_ID
AND PADR.ADDRESS_TYPE(+) = 'JP_R'
AND NVL(PPI.ACTUAL_TERMINATION_DATE
, TO_DATE(LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(PPI.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(+) = PPI.PERSON_ID
AND PADC.ADDRESS_TYPE(+) = 'JP_C'
AND NVL(PPI.ACTUAL_TERMINATION_DATE
, TO_DATE(LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(PPI.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