eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PAY_US_EMP_W4DTL_ACTION_INFO_V

Line 2007: ,(select status from pay_us_emp_w4dtl_action_info_v

2003: ,payroll_name
2004: ,'USD'
2005: ,to_char(ending_date,'YYYY-MM-DD')
2006: ,'Federal'
2007: ,(select status from pay_us_emp_w4dtl_action_info_v
2008: where action_context_id = p_asg_action_id
2009: and tax_jurisdiction = 'Federal'
2010: and trunc(effective_date) <= p_eff_date) STATUS
2011:

Line 2012: ,(select exemptions from pay_us_emp_w4dtl_action_info_v

2008: where action_context_id = p_asg_action_id
2009: and tax_jurisdiction = 'Federal'
2010: and trunc(effective_date) <= p_eff_date) STATUS
2011:
2012: ,(select exemptions from pay_us_emp_w4dtl_action_info_v
2013: where action_context_id = p_asg_action_id
2014: and assignment_id = p_asg_id
2015: and trunc(effective_date) <= p_eff_date
2016: and tax_jurisdiction = 'Federal') EXEMPTIONS

Line 2018: ,(select additional_tax_amount from pay_us_emp_w4dtl_action_info_v

2014: and assignment_id = p_asg_id
2015: and trunc(effective_date) <= p_eff_date
2016: and tax_jurisdiction = 'Federal') EXEMPTIONS
2017:
2018: ,(select additional_tax_amount from pay_us_emp_w4dtl_action_info_v
2019: where action_context_id = p_asg_action_id
2020: and assignment_id = p_asg_id
2021: and trunc(effective_date) <= p_eff_date
2022: and tax_jurisdiction = 'Federal') ADDNL_TAX_AMOUNT

Line 2024: ,(select override_tax_amount from pay_us_emp_w4dtl_action_info_v

2020: and assignment_id = p_asg_id
2021: and trunc(effective_date) <= p_eff_date
2022: and tax_jurisdiction = 'Federal') ADDNL_TAX_AMOUNT
2023:
2024: ,(select override_tax_amount from pay_us_emp_w4dtl_action_info_v
2025: where action_context_id = p_asg_action_id
2026: and assignment_id = p_asg_id
2027: and trunc(effective_date) <= p_eff_date
2028: and tax_jurisdiction = 'Federal') OVERRIDE_TAX_AMOUNT

Line 2030: ,(select override_tax_percentage from pay_us_emp_w4dtl_action_info_v

2026: and assignment_id = p_asg_id
2027: and trunc(effective_date) <= p_eff_date
2028: and tax_jurisdiction = 'Federal') OVERRIDE_TAX_AMOUNT
2029:
2030: ,(select override_tax_percentage from pay_us_emp_w4dtl_action_info_v
2031: where action_context_id = p_asg_action_id
2032: and assignment_id = p_asg_id
2033: and trunc(effective_date) <= p_eff_date
2034: and tax_jurisdiction = 'Federal') OVERRIDE_TAX_PERCENTAGE

Line 2037: ,(select exemptions from pay_us_emp_w4dtl_action_info_v

2033: and trunc(effective_date) <= p_eff_date
2034: and tax_jurisdiction = 'Federal') OVERRIDE_TAX_PERCENTAGE
2035: ,p_state_code
2036:
2037: ,(select exemptions from pay_us_emp_w4dtl_action_info_v
2038: where action_context_id = p_asg_action_id
2039: and assignment_id = p_asg_id
2040: and trunc(effective_date) <= p_eff_date
2041: and tax_jurisdiction = p_state_desc) STEXEMPTIONS

Line 2043: ,(select additional_tax_amount from pay_us_emp_w4dtl_action_info_v

2039: and assignment_id = p_asg_id
2040: and trunc(effective_date) <= p_eff_date
2041: and tax_jurisdiction = p_state_desc) STEXEMPTIONS
2042:
2043: ,(select additional_tax_amount from pay_us_emp_w4dtl_action_info_v
2044: where action_context_id = p_asg_action_id
2045: and assignment_id = p_asg_id
2046: and trunc(effective_date) <= p_eff_date
2047: and tax_jurisdiction = p_state_desc) STADDNL_TAX_AMOUNT

Line 2049: ,(select override_tax_amount from pay_us_emp_w4dtl_action_info_v

2045: and assignment_id = p_asg_id
2046: and trunc(effective_date) <= p_eff_date
2047: and tax_jurisdiction = p_state_desc) STADDNL_TAX_AMOUNT
2048:
2049: ,(select override_tax_amount from pay_us_emp_w4dtl_action_info_v
2050: where action_context_id = p_asg_action_id
2051: and assignment_id = p_asg_id
2052: and trunc(effective_date) <= p_eff_date
2053: and tax_jurisdiction = p_state_desc) STOVERRIDE_TAX_AMOUNT

Line 2055: ,(select override_tax_percentage from pay_us_emp_w4dtl_action_info_v

2051: and assignment_id = p_asg_id
2052: and trunc(effective_date) <= p_eff_date
2053: and tax_jurisdiction = p_state_desc) STOVERRIDE_TAX_AMOUNT
2054:
2055: ,(select override_tax_percentage from pay_us_emp_w4dtl_action_info_v
2056: where action_context_id = p_asg_action_id
2057: and assignment_id = p_asg_id
2058: and trunc(effective_date) <= p_eff_date
2059: and tax_jurisdiction = p_state_desc) STOVERRIDE_TAX_PERCENTAGE