Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_US_SCHOOL_ARCHIVE |
SELECT PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, PAI.JURISDICTION_CODE
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_JURISDICTION_NAME(PAI.JURISDICTION_CODE) JURISDICTION_NAME
, PAY_AC_UTIL.GET_STATE_ABBREV(PAI.JURISDICTION_CODE) STATE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) SCHOOL_GROSS
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION1)
, 0) SCHOOL_WITHHELD
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) SCHOOL_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) SCHOOL_SUBJ_NWHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) 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' WITH READ ONLY