VIEW: APPS.PAY_US_STATE_ACTION_INFO_V

Source

View Text - Preformatted

SELECT 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, pai.effective_date effective_date, to_number(pai.action_information17) SIT_Gross, to_number(pai.action_information2 ) SIT_Subj_Whable, to_number(pai.action_information3 ) SIT_Subj_NWhable, to_number(pai.action_information4 ) SIT_Pre_Tax_Redns, nvl(to_number(pai.action_information2 ), 0) + nvl(to_number(pai.action_information3 ), 0) SIT_Subject, nvl(to_number(pai.action_information2 ), 0) - nvl(to_number(pai.action_information4 ), 0) SIT_Reduced_Subject, to_number(pai.action_information1 ) SIT_Withheld, to_number(pai.action_information26 ) SDI_EE_Gross, to_number(pai.action_information6 ) SDI_EE_Taxable, to_number(pai.action_information7 ) SDI_EE_Subj_Whable, to_number(pai.action_information8 ) SDI_EE_Pre_Tax_Redns, nvl(to_number(pai.action_information7 ), 0) - nvl(to_number(pai.action_information8 ), 0) SDI_EE_Reduced_Subject, to_number(pai.action_information5 ) SDI_EE_Withheld, to_number(pai.action_information27 ) SDI_ER_Gross, to_number(pai.action_information10) SDI_ER_Taxable, to_number(pai.action_information11) SDI_ER_Subj_Whable, to_number(pai.action_information12) SDI_ER_Pre_Tax_Redns, nvl(to_number(pai.action_information11), 0) - nvl(to_number(pai.action_information12), 0) SDI_ER_Reduced_Subject, to_number(pai.action_information9 ) SDI_ER_Liability, to_number(pai.action_information28) SUI_EE_Gross, to_number(pai.action_information14) SUI_EE_Taxable, to_number(pai.action_information15) SUI_EE_Subj_Whable, to_number(pai.action_information16) SUI_EE_Pre_Tax_Redns, nvl(to_number(pai.action_information15), 0) - nvl(to_number(pai.action_information16), 0) SUI_EE_Reduced_Subject, to_number(pai.action_information13) SUI_EE_Withheld, to_number(pai.action_information29) SUI_ER_Gross, to_number(pai.action_information18) SUI_ER_Taxable, to_number(pai.action_information19) SUI_ER_Subj_Whable, to_number(pai.action_information20) SUI_ER_Pre_Tax_Redns, nvl(to_number(pai.action_information19), 0) - nvl(to_number(pai.action_information20), 0) SUI_ER_Reduced_Subject, to_number(pai.action_information21) SUI_ER_Liability, to_number(pai.action_information22) Workers_Comp_Withheld, to_number(pai.action_information23) Workers_Comp2_Withheld, to_number(pai.action_information24) Workers_Comp2_ER, to_number(pai.action_information25) Workers_Comp3_ER, NVL(to_number(pai2.action_information1),0) SDI1_EE_Withheld from pay_action_information pai, PAY_ACTION_INFORMATION PAI2 WHERE pai.action_information_category = 'US STATE' AND PAI2.ACTION_INFORMATION_CATEGORY (+) = 'US STATE2' AND pai.jurisdiction_code = pai2.jurisdiction_code (+) AND pai.action_context_id = pai2.action_context_id (+) AND pai.effective_date = pai2.effective_date (+) AND pai.assignment_id = pai2.assignment_id (+)

View Text - HTML Formatted

SELECT 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
, PAI.EFFECTIVE_DATE EFFECTIVE_DATE
, TO_NUMBER(PAI.ACTION_INFORMATION17) SIT_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION2 ) SIT_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION3 ) SIT_SUBJ_NWHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION4 ) SIT_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3 )
, 0) SIT_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4 )
, 0) SIT_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION1 ) SIT_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION26 ) SDI_EE_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION6 ) SDI_EE_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION7 ) SDI_EE_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION8 ) SDI_EE_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION7 )
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION8 )
, 0) SDI_EE_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION5 ) SDI_EE_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION27 ) SDI_ER_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION10) SDI_ER_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION11) SDI_ER_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION12) SDI_ER_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION12)
, 0) SDI_ER_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION9 ) SDI_ER_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION28) SUI_EE_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION14) SUI_EE_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION15) SUI_EE_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION16) SUI_EE_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION15)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION16)
, 0) SUI_EE_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION13) SUI_EE_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION29) SUI_ER_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION18) SUI_ER_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION19) SUI_ER_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION20) SUI_ER_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION20)
, 0) SUI_ER_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION21) SUI_ER_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION22) WORKERS_COMP_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION23) WORKERS_COMP2_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION24) WORKERS_COMP2_ER
, TO_NUMBER(PAI.ACTION_INFORMATION25) WORKERS_COMP3_ER
, NVL(TO_NUMBER(PAI2.ACTION_INFORMATION1)
, 0) SDI1_EE_WITHHELD
FROM PAY_ACTION_INFORMATION PAI
, PAY_ACTION_INFORMATION PAI2
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US STATE'
AND PAI2.ACTION_INFORMATION_CATEGORY (+) = 'US STATE2'
AND PAI.JURISDICTION_CODE = PAI2.JURISDICTION_CODE (+)
AND PAI.ACTION_CONTEXT_ID = PAI2.ACTION_CONTEXT_ID (+)
AND PAI.EFFECTIVE_DATE = PAI2.EFFECTIVE_DATE (+)
AND PAI.ASSIGNMENT_ID = PAI2.ASSIGNMENT_ID (+)