VIEW: APPS.PAY_US_COUNTY_ACTION_INFO_V

Source

View Text - Preformatted

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_information7) County_Gross, to_number(pai.action_information1) County_Withheld, to_number(pai.action_information2) County_Subj_Whable, to_number(pai.action_information3) County_Subj_NWable, to_number(pai.action_information4) County_Pre_Tax_Redns, nvl(to_number(pai.action_information2), 0) + nvl(to_number(pai.action_information3), 0) County_Subject, nvl(to_number(pai.action_information2), 0) - nvl(to_number(pai.action_information4), 0) County_Reduced_Subject, to_number(pai.action_information5) Head_Tax_Liability, to_number(pai.action_information6) Head_Tax_Withheld, pai.action_information30 non_resident_flag from pay_action_information pai WHERE pai.action_information_category = 'US COUNTY'

View Text - HTML Formatted

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_INFORMATION7) COUNTY_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION1) COUNTY_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION2) COUNTY_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION3) COUNTY_SUBJ_NWABLE
, TO_NUMBER(PAI.ACTION_INFORMATION4) COUNTY_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) COUNTY_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) COUNTY_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION5) HEAD_TAX_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION6) HEAD_TAX_WITHHELD
, PAI.ACTION_INFORMATION30 NON_RESIDENT_FLAG
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US COUNTY'