VIEW: APPS.PAY_US_CITY_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) City_Gross, to_number(pai.action_information1) City_Withheld, to_number(pai.action_information2) City_Subj_Whable, to_number(pai.action_information3) City_Subj_NWable, to_number(pai.action_information4) City_Pre_Tax_Redns, nvl(to_number(pai.action_information2), 0) + nvl(to_number(pai.action_information3), 0) City_Subject, nvl(to_number(pai.action_information2), 0) - nvl(to_number(pai.action_information4), 0) City_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 CITY'

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) CITY_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION1) CITY_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION2) CITY_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION3) CITY_SUBJ_NWABLE
, TO_NUMBER(PAI.ACTION_INFORMATION4) CITY_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) CITY_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) CITY_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 CITY'