View: PAY_US_STATE_W2_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_US_STATE_W2_V

View Text

SELECT TO_NUMBER(TO_CHAR(PPA.EFFECTIVE_DATE
, 'YYYY')) YEAR
, PPA.EFFECTIVE_DATE
, PAA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PAA.TAX_UNIT_ID
, PAA.ACTION_STATUS
, SUBSTR(FAIC.CONTEXT
, 1
, 2) STATE_CODE
, FAI.VALUE STATE_ABBREV
, NVL(HR_US_W2_REP.GET_STATE_ITEM( PAA.TAX_UNIT_ID
, FAIC.CONTEXT
, PAA.PAYROLL_ACTION_ID
, 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID')
, 'NO STATE EIN' ) STATE_EIN
, NVL(HR_US_W2_REP.GET_STATE_ITEM( PAA.TAX_UNIT_ID
, FAIC.CONTEXT
, PAA.PAYROLL_ACTION_ID
, 'A_STATE_TAX_RULES_ORG_SUI_COMPANY_STATE_ID')
, 'NO STATE UIN' ) STATE_UIN
, FAIC.CONTEXT JURISDICTION_CODE
, HR_US_W2_REP.GET_W2_ARCH_BAL(PAA.ASSIGNMENT_ACTION_ID
, 'A_W2_STATE_WAGES'
, PAA.TAX_UNIT_ID
, FAIC.CONTEXT
, 2)
, HR_US_W2_REP.GET_W2_ARCH_BAL(PAA.ASSIGNMENT_ACTION_ID
, 'A_SIT_WITHHELD_PER_JD_GRE_YTD'
, PAA.TAX_UNIT_ID
, FAIC.CONTEXT
, 2)
, PAA.SERIAL_NUMBER
, PPA.BUSINESS_GROUP_ID
FROM FF_ARCHIVE_ITEM_CONTEXTS FAIC
, FF_ARCHIVE_ITEMS FAI
, FF_DATABASE_ITEMS FDI
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.REPORT_TYPE = 'YREND'
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND FDI.USER_NAME = 'A_STATE_ABBREV'
AND FDI.USER_ENTITY_ID = FAI.USER_ENTITY_ID
AND FAI.ARCHIVE_ITEM_ID = FAIC.ARCHIVE_ITEM_ID
AND FAI.CONTEXT1 = PAA.ASSIGNMENT_ACTION_ID
AND EXISTS ( SELECT 'X'
FROM PAY_US_STATE_TAX_INFO_F PUSTIF
WHERE SUBSTR(FAIC.CONTEXT
, 1
, 2) = PUSTIF.STATE_CODE
AND PPA.EFFECTIVE_DATE BETWEEN PUSTIF.EFFECTIVE_START_DATE
AND PUSTIF.EFFECTIVE_END_DATE
AND PUSTIF.SIT_EXISTS = 'Y')

Columns