VIEW: APPS.PAYBV_US_LOCAL_ARCHIVE

Source

View Text - Preformatted

SELECT pai.action_context_id action_number, pai.tax_unit_id, pai.effective_date, pai.assignment_id, pai.jurisdiction_code, pay_ac_util.get_jurisdiction_name(pai.jurisdiction_code) jurisdiction_name, substr(pai.jurisdiction_code,1,2) state_code , pay_ac_util.get_state_abbrev(pai.jurisdiction_code) state_abbrev, nvl(to_number(decode(pai.action_information_category, 'US SCHOOL DISTRICT', pai.action_information5,pai.action_information7)),0) Local_Gross, nvl(to_number(pai.action_information1),0) Local_Withheld, nvl(to_number(pai.action_information2),0) Local_Subj_Whable, nvl(to_number(pai.action_information3),0) Local_Subj_NWable, nvl(to_number(pai.action_information4),0) Local_Pre_Tax_Redns, (nvl(to_number(pai.action_information2), 0) + nvl(to_number(pai.action_information3), 0) ) Local_Subject, (nvl(to_number(pai.action_information2), 0) - nvl(to_number(pai.action_information4), 0) ) Local_Reduced_Subject, nvl(to_number(decode(pai.action_information_category, 'US SCHOOL DISTRICT', 0,pai.action_information5)),0) Local_Head_Tax_Liability, nvl(to_number(decode(pai.action_information_category, 'US SCHOOL DISTRICT', 0,pai.action_information6)),0) Local_Head_Tax_Withheld from pay_action_information pai WHERE pai.action_information_category in ('US CITY', 'US COUNTY', 'US SCHOOL DISTRICT') with read only

View Text - HTML Formatted

SELECT PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, PAI.JURISDICTION_CODE
, PAY_AC_UTIL.GET_JURISDICTION_NAME(PAI.JURISDICTION_CODE) JURISDICTION_NAME
, SUBSTR(PAI.JURISDICTION_CODE
, 1
, 2) STATE_CODE
, PAY_AC_UTIL.GET_STATE_ABBREV(PAI.JURISDICTION_CODE) STATE_ABBREV
, NVL(TO_NUMBER(DECODE(PAI.ACTION_INFORMATION_CATEGORY
, 'US SCHOOL DISTRICT'
, PAI.ACTION_INFORMATION5
, PAI.ACTION_INFORMATION7))
, 0) LOCAL_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION1)
, 0) LOCAL_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) LOCAL_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) LOCAL_SUBJ_NWABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) LOCAL_PRE_TAX_REDNS
, (NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) ) LOCAL_SUBJECT
, (NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) ) LOCAL_REDUCED_SUBJECT
, NVL(TO_NUMBER(DECODE(PAI.ACTION_INFORMATION_CATEGORY
, 'US SCHOOL DISTRICT'
, 0
, PAI.ACTION_INFORMATION5))
, 0) LOCAL_HEAD_TAX_LIABILITY
, NVL(TO_NUMBER(DECODE(PAI.ACTION_INFORMATION_CATEGORY
, 'US SCHOOL DISTRICT'
, 0
, PAI.ACTION_INFORMATION6))
, 0) LOCAL_HEAD_TAX_WITHHELD
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY IN ('US CITY'
, 'US COUNTY'
, 'US SCHOOL DISTRICT') WITH READ ONLY