VIEW: APPS.HR_H2PI_FEDERAL_TAX_RULES_V

Source

View Text - Preformatted

SELECT asg.person_id, fed.emp_fed_tax_rule_id, fed.effective_start_date, fed.effective_end_date, fed.assignment_id, fed.sui_state_code, fed.sui_jurisdiction_code, fed.business_group_id, fed.additional_wa_amount, fed.filing_status_code, fed.fit_override_amount, fed.fit_override_rate, fed.withholding_allowances, fed.cumulative_taxation, fed.eic_filing_status_code, fed.fit_additional_tax, fed.fit_exempt, fed.futa_tax_exempt, fed.medicare_tax_exempt, fed.ss_tax_exempt, fed.statutory_employee, fed.w2_filed_year, fed.supp_tax_override_rate, fed.excessive_wa_reject_date, fed.last_update_date, fed.object_version_number from pay_us_emp_fed_tax_rules_f fed, hr_h2pi_assignments_v asg WHERE fed.assignment_id = asg.assignment_id and fed.effective_start_date between asg.effective_start_date and asg.effective_end_date

View Text - HTML Formatted

SELECT ASG.PERSON_ID
, FED.EMP_FED_TAX_RULE_ID
, FED.EFFECTIVE_START_DATE
, FED.EFFECTIVE_END_DATE
, FED.ASSIGNMENT_ID
, FED.SUI_STATE_CODE
, FED.SUI_JURISDICTION_CODE
, FED.BUSINESS_GROUP_ID
, FED.ADDITIONAL_WA_AMOUNT
, FED.FILING_STATUS_CODE
, FED.FIT_OVERRIDE_AMOUNT
, FED.FIT_OVERRIDE_RATE
, FED.WITHHOLDING_ALLOWANCES
, FED.CUMULATIVE_TAXATION
, FED.EIC_FILING_STATUS_CODE
, FED.FIT_ADDITIONAL_TAX
, FED.FIT_EXEMPT
, FED.FUTA_TAX_EXEMPT
, FED.MEDICARE_TAX_EXEMPT
, FED.SS_TAX_EXEMPT
, FED.STATUTORY_EMPLOYEE
, FED.W2_FILED_YEAR
, FED.SUPP_TAX_OVERRIDE_RATE
, FED.EXCESSIVE_WA_REJECT_DATE
, FED.LAST_UPDATE_DATE
, FED.OBJECT_VERSION_NUMBER
FROM PAY_US_EMP_FED_TAX_RULES_F FED
, HR_H2PI_ASSIGNMENTS_V ASG
WHERE FED.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND FED.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE