VIEW: APPS.PAY_US_W2_TAX_UNIT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'