View: PAY_US_W2_TAX_UNIT_V

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

View Text

SELECT TO_NUMBER(TO_CHAR(EFFECTIVE_DATE
, 'YYYY')) YEAR
, TO_NUMBER(RTRIM(SUBSTR(LEGISLATIVE_PARAMETERS
, INSTR( LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE=' )))) TAX_UNIT_ID
, HR_US_W2_REP.GET_TAX_UNIT_BG(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))) BUSINESS_GROUP_ID
, NVL(HR_US_W2_REP.GET_W2_TAX_UNIT_ITEM(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, PAYROLL_ACTION_ID
, 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER')
, 'APPLIED FOR' ) FEDERAL_EIN
, HR_US_W2_REP.GET_W2_TAX_UNIT_ITEM(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, PAYROLL_ACTION_ID
, 'A_TAX_UNIT_NAME' ) TAX_UNIT_NAME
, HR_US_W2_REP.GET_TAX_UNIT_ADDR_LINE(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, 'ADDR1') ADDRESS_LINE_1
, HR_US_W2_REP.GET_TAX_UNIT_ADDR_LINE(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, 'ADDR2') ADDRESS_LINE_2
, HR_US_W2_REP.GET_TAX_UNIT_ADDR_LINE(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, 'ADDR3') ADDRESS_LINE_3
, HR_US_W2_REP.GET_TAX_UNIT_ADDR_LINE(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, 'CITY') TOWN_OR_CITY
, HR_US_W2_REP.GET_TAX_UNIT_ADDR_LINE(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, 'STATE') STATE
, HR_US_W2_REP.GET_TAX_UNIT_ADDR_LINE(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, 'COUNTRY') COUNTRY
, HR_US_W2_REP.GET_TAX_UNIT_ADDR_LINE(TO_NUMBER(RTRIM(SUBSTR( LEGISLATIVE_PARAMETERS
, INSTR(LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=' )+LENGTH('TRANSFER_GRE='))))
, 'ZIP') POSTAL_CODE
FROM PAY_PAYROLL_ACTIONS
WHERE REPORT_TYPE = 'YREND'
AND REPORT_QUALIFIER = 'FED'
AND REPORT_CATEGORY = 'RT'

Columns