Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_WIC_ASSACTS_V2 |
SELECT WIC.ASSIGNMENT_ACTION_ID
, WIC.ASSIGNMENT_ID
, WIC.ACTION_SEQUENCE
, WIC.PAYROLL_ACTION_ID
, WIC.BUSINESS_GROUP_ID
, WIC.PAYROLL_ID
, WIC.EFFECTIVE_DATE
, WIC.DATE_EARNED
, WIC.ITAX_ORGANIZATION_ID
, WIC.SALARY_CATEGORY
, WIC.ITAX_CATEGORY
, /* RETURN '-1' WHEN ANY FUTURE ASSACTS EXIST AFTER YEA. NOTE IF ANY FUTURE ASSACTS EXIST AFTER YEA EVEN THE YEA BELONGS TO DIFFERENT SWOT
, THIS YEA IS NOT REGARDED AS YEA
, BUT JUST AS NORMAL PAYMENT
, WHICH MEANS "PREVIOUS JOBS AMOUNT"
AND "ADJUSTMENT AMOUNT" DOES NOT CONTRIBUTE TO THE TOTAL AMOUNT. */ (CASE WHEN WIC.ITAX_YEA_CATEGORY IS NOT NULL THEN (CASE WHEN ( SELECT COUNT(*)
FROM PAY_JP_WIC_ASSACTS_V1 WIC2
WHERE WIC2.ASSIGNMENT_ID = WIC.ASSIGNMENT_ID
AND WIC2.ACTION_SEQUENCE > WIC.ACTION_SEQUENCE
AND WIC2.EFFECTIVE_DATE < ADD_MONTHS(TRUNC(WIC.EFFECTIVE_DATE
, 'YYYY')
, 12)) > 0 THEN '-1' ELSE WIC.ITAX_YEA_CATEGORY END) ELSE NULL END)
, WIC.PERSON_ID
, WIC.PERIOD_OF_SERVICE_ID
, (CASE WHEN WIC.DATE_START >= TRUNC(WIC.EFFECTIVE_DATE
, 'YYYY') THEN WIC.DATE_START ELSE NULL END)
, (CASE WHEN WIC.EFFECTIVE_DATE >= TRUNC(WIC.ACTUAL_TERMINATION_DATE
, 'YYYY') THEN WIC.LEAVING_REASON ELSE NULL END)
, (CASE WHEN WIC.EFFECTIVE_DATE >= TRUNC(WIC.ACTUAL_TERMINATION_DATE
, 'YYYY') THEN WIC.ACTUAL_TERMINATION_DATE ELSE NULL END)
, WIC.TAXABLE_AMT
, WIC.SI_PREM
, WIC.MUTUAL_AID
, WIC.ITAX
, WIC.ITAX_ADJUSTMENT
, WIC.DISASTER_TAX_REDUCTION
, WIC.EMPLOYMENT_CATEGORY
, WIC.LEGISLATIVE_PARAMETERS
FROM PAY_JP_WIC_ASSACTS_V1 WIC