View: PAY_JP_WIC_ASSACTS_V

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

View Text

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
, WIC.ITAX_YEA_CATEGORY
, WIC.PERSON_ID
, WIC.PERIOD_OF_SERVICE_ID
, WIC.DATE_START
, WIC.LEAVING_REASON
, WIC.ACTUAL_TERMINATION_DATE
, WIC.EMPLOYMENT_CATEGORY
, WIC.LEGISLATIVE_PARAMETERS
FROM PAY_JP_WIC_ASSACTS_V2 WIC
WHERE NOT EXISTS( SELECT NULL
FROM PAY_JP_WIC_ASSACTS_V2 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)
AND WIC2.ITAX_ORGANIZATION_ID = WIC.ITAX_ORGANIZATION_ID
AND (/* EXCLUDE ASSACTS WITH THE SAME KIND OF "TAX CATEGORY". */ ((WIC.ITAX_CATEGORY IN ('M_KOU'
, 'D_KOU')
AND WIC2.ITAX_CATEGORY IN ('M_KOU'
, 'D_KOU')) OR (WIC.ITAX_CATEGORY IN ('M_OTSU'
, 'D_OTSU')
AND WIC2.ITAX_CATEGORY IN ('M_OTSU'
, 'D_OTSU')) OR (WIC.ITAX_CATEGORY = 'D_HEI'
AND WIC2.ITAX_CATEGORY = 'D_HEI')) OR /* EXCLUDE ASSACTS HAVING "VALID" FUTURE YEA ASSACT. */ (WIC2.ITAX_YEA_CATEGORY = '0')))

Columns