View: PAY_JP_WIC_ASSACTS_V1

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

View Text

SELECT /*+ USE_NL(PPA
, PAA
, PAI) INDEX(PPA) INDEX(PAI PAY_ACTION_INFORMATION_N3) */ PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PAA.ACTION_SEQUENCE
, PPA.PAYROLL_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, PPA.PAYROLL_ID
, PPA.EFFECTIVE_DATE
, PPA.DATE_EARNED
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION21)
, PAI.ACTION_INFORMATION13
, PAI.ACTION_INFORMATION22
, PAI.ACTION_INFORMATION23
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION4)
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION15)
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION16)
, PAI.ACTION_INFORMATION17
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION18)
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION2) + FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION3)
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION6) + FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION9) + FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12) + FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION20) + FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION14)
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION14)
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION24)
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION25)
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION29)
, PAI.ACTION_INFORMATION30
, PPA.LEGISLATIVE_PARAMETERS
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INFORMATION PAI
WHERE PPA.ACTION_TYPE IN ('R'
, 'Q'
, 'B'
, 'I')
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PAA.ACTION_STATUS = 'C'
AND PAI.ACTION_INFORMATION_CATEGORY = 'JP_PRE_TAX_1'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION1 = TO_CHAR(PAA.ASSIGNMENT_ACTION_ID)
AND PAI.ASSIGNMENT_ID + 0 = PAA.ASSIGNMENT_ID
AND PAI.ACTION_INFORMATION13 IN ('SALARY'
, 'BONUS'
, 'SP_BONUS'
, 'YEA'
, 'RE_YEA')
AND PAI.ACTION_INFORMATION22 IN ('M_KOU'
, 'D_KOU'
, 'M_OTSU'
, 'D_OTSU'
, 'D_HEI') /* EXCLUDE PAYMENTS AFTER DATE OF DEATH (EXLUDING YEA ASSACTS). */
AND (PAI.ACTION_INFORMATION13 IN ('YEA'
, 'RE_YEA') OR PAI.ACTION_INFORMATION17 IS NULL /* LEAVING_REASON */ OR PAI.ACTION_INFORMATION17 NOT LIKE 'D%' OR PAI.ACTION_INFORMATION18 IS NULL /* ACTUAL_TERMINATION_DATE */ OR PPA.EFFECTIVE_DATE <= FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION18)) /* EXCLUDE REVERSED ACTIONS. */
AND NOT EXISTS( SELECT /* ORDERED USE_NL(PAIL
, PAAV
, PPAV) INDEX(PAIL PAY_ACTION_INTERLOCKS_FK2) INDEX(PAAV PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PPAV PAY_PAYROLL_ACTIONS_PK) */ NULL
FROM PAY_ACTION_INTERLOCKS PAIL
, PAY_ASSIGNMENT_ACTIONS PAAV
, PAY_PAYROLL_ACTIONS PPAV
WHERE PAIL.LOCKED_ACTION_ID = DECODE(PAI.ACTION_INFORMATION_CATEGORY
, 'JP_PRE_TAX_1'
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION1)
, -1)
AND PAAV.ASSIGNMENT_ACTION_ID = PAIL.LOCKING_ACTION_ID
AND PPAV.PAYROLL_ACTION_ID = PAAV.PAYROLL_ACTION_ID
AND PPAV.ACTION_TYPE = 'V')

Columns