VIEW: APPS.PAYBV_US_SCHOOL_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_us_employee_payslip_web.get_jurisdiction_name(pai.jurisdiction_code) jurisdiction_name, pay_ac_util.get_state_abbrev(pai.jurisdiction_code) state, nvl(to_number(pai.action_information5),0) School_Gross, nvl( to_number(pai.action_information1),0) School_Withheld, nvl( to_number(pai.action_information2),0) School_Subj_Whable, nvl(to_number(pai.action_information3),0) School_Subj_NWhable, nvl(to_number(pai.action_information4),0) School_Pre_Tax_Redns, nvl(to_number(pai.action_information2),0) + nvl(to_number(pai.action_information3),0) School_Subject, nvl(to_number(pai.action_information2),0) - nvl(to_number(pai.action_information4),0) School_Reduced_Subject from pay_action_information pai WHERE pai.action_information_category = '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_US_EMPLOYEE_PAYSLIP_WEB.GET_JURISDICTION_NAME(PAI.JURISDICTION_CODE) JURISDICTION_NAME
, PAY_AC_UTIL.GET_STATE_ABBREV(PAI.JURISDICTION_CODE) STATE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) SCHOOL_GROSS
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION1)
, 0) SCHOOL_WITHHELD
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) SCHOOL_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) SCHOOL_SUBJ_NWHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) SCHOOL_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) SCHOOL_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) SCHOOL_REDUCED_SUBJECT
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US SCHOOL DISTRICT' WITH READ ONLY