View: PAY_JP_LABOR_INS_V

Product:	PAY - Payroll
Description:	This view is used by Japanese statutory report of KAKUTEI HOKEN RYO SANTEI KISO CHINGIN SYUKEI HYO(PAYJPFLI).
Implementation/DBA Data:	APPS.PAY_JP_LABOR_INS_V

View Text

SELECT PPT.SALARY_CATEGORY
, TO_CHAR(PPA.EFFECTIVE_DATE
, 'YYYYMM')
, PPA.BUSINESS_GROUP_ID
, PAA.ASSIGNMENT_ID
, PPT.UI_ORGANIZATION_ID
, PPT.UI_CATEGORY
, SUM(PPT.UI_SAL_AMT)
, PPT.WAI_ORGANIZATION_ID
, PPT.WAI_CATEGORY
, SUM(PPT.WAI_SAL_AMT) FROM PAY_JP_PRE_TAX PPT
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA WHERE PPA.ACTION_TYPE IN ('R'
, 'Q'
, 'B'
, 'I') AND PAA.PAYROLL_ACTION_ID=PPA.PAYROLL_ACTION_ID AND PPA.ACTION_STATUS='C' AND PPT.ASSIGNMENT_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID AND PPT.ACTION_STATUS='C' AND PPT.SALARY_CATEGORY IN ('SALARY'
, 'BONUS'
, 'SP_BONUS') AND NOT EXISTS( SELECT NULL FROM PAY_PAYROLL_ACTIONS PPA2
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_ACTION_INTERLOCKS PAI WHERE PAI.LOCKED_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID AND PAA2.ASSIGNMENT_ACTION_ID=PAI.LOCKING_ACTION_ID AND PPA2.PAYROLL_ACTION_ID=PAA2.PAYROLL_ACTION_ID AND PPA2.ACTION_TYPE='V') GROUP BY PPT.SALARY_CATEGORY
, TO_CHAR(PPA.EFFECTIVE_DATE
, 'YYYYMM')
, PPA.BUSINESS_GROUP_ID
, PAA.ASSIGNMENT_ID
, PPT.UI_ORGANIZATION_ID
, PPT.UI_CATEGORY
, PPT.WAI_ORGANIZATION_ID
, PPT.WAI_CATEGORY

Columns