Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_US_SCHOOL_ACTION_INFO_V |
SELECT PAI.EFFECTIVE_DATE
, PAI.JURISDICTION_CODE
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_JURISDICTION_NAME(PAI.JURISDICTION_CODE) JURISDICTION_NAME
, PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.ASSIGNMENT_ID
, TO_NUMBER(PAI.ACTION_INFORMATION5) SCHOOL_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION1) SCHOOL_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION2) SCHOOL_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION3) SCHOOL_SUBJ_NWHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION4) SCHOOL_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) SCHOOL_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) SCHOOL_REDUCED_SUBJECT
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US SCHOOL DISTRICT'