[Home] [Help]
View: PAY_JP_TAX_SWOT_WITHHELD_V
Product: | PAY - Payroll |
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
BUSINESS_GROUP_ID |
YEAR |
TAX_ORGANIZATION_ID |
EFFECTIVE_DATE |
DATE_EARNED |
ASSIGNMENT_ACTION_ID |
PERSON_ID |
PERIOD_OF_SERVICE_ID |
TAX_CATEGORY |
TAX_YEA_CATEGORY |
TOWN_OR_CITY |