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.

APPS.PAY_US_TAX_INTERNAL dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 171: from pay_us_emp_fed_tax_rules_f

167: --
168:
169: cursor csr_defaulting_date(p_assignment_id number) is
170: select min(effective_start_date)
171: from pay_us_emp_fed_tax_rules_f
172: where assignment_id = p_assignment_id;
173:
174: --
175: -- ----------------------------------------------------------------------------

Line 2002: l_assignment_id pay_us_emp_fed_tax_rules_f.assignment_id%TYPE;

1998: --
1999: -- Declare cursors and local variables
2000: --
2001: l_proc varchar2(72) := g_package||'maintain_wc';
2002: l_assignment_id pay_us_emp_fed_tax_rules_f.assignment_id%TYPE;
2003: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;
2004: l_element_type_id number :=0;
2005: l_inp_name varchar2(50) :=null;
2006: l_inp_val_id number :=0;

Line 2003: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;

1999: -- Declare cursors and local variables
2000: --
2001: l_proc varchar2(72) := g_package||'maintain_wc';
2002: l_assignment_id pay_us_emp_fed_tax_rules_f.assignment_id%TYPE;
2003: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;
2004: l_element_type_id number :=0;
2005: l_inp_name varchar2(50) :=null;
2006: l_inp_val_id number :=0;
2007: l_element_link_id number :=0;

Line 2015: l_wc_min_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

2011: l_effective_date date;
2012: l_mode varchar2(30);
2013: l_delete_flag varchar2(1);
2014: l_payroll_installed boolean := FALSE;
2015: l_wc_min_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2016: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2017: l_get_old_value_date date;
2018: l_temp_char varchar2(2);
2019: lc_workers_comp varchar2(25) := 'Workers Compensation';

Line 2016: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

2012: l_mode varchar2(30);
2013: l_delete_flag varchar2(1);
2014: l_payroll_installed boolean := FALSE;
2015: l_wc_min_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2016: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2017: l_get_old_value_date date;
2018: l_temp_char varchar2(2);
2019: lc_workers_comp varchar2(25) := 'Workers Compensation';
2020: l_tmp_date date;

Line 2030: from pay_us_emp_fed_tax_rules_f fed

2026:
2027: cursor csr_fed_detail is
2028: select fed.assignment_id,
2029: fed.sui_jurisdiction_code
2030: from pay_us_emp_fed_tax_rules_f fed
2031: where fed.emp_fed_tax_rule_id = p_emp_fed_tax_rule_id
2032: and l_get_old_value_date between fed.effective_start_date
2033: and fed.effective_end_date;
2034:

Line 2039: from pay_us_emp_fed_tax_rules_f fed

2035: /* Cursor to check for existence of the federal tax rule */
2036:
2037: cursor csr_fed_rule_exists is
2038: select null
2039: from pay_us_emp_fed_tax_rules_f fed
2040: where fed.emp_fed_tax_rule_id = p_emp_fed_tax_rule_id
2041: and fed.effective_start_date = l_effective_end_date + 1;
2042:
2043: /* Cursor to get the tax defaulting date */

Line 2047: from pay_us_emp_fed_tax_rules_f

2043: /* Cursor to get the tax defaulting date */
2044:
2045: cursor csr_min_fed_tax_date is
2046: select min(effective_start_date)
2047: from pay_us_emp_fed_tax_rules_f
2048: where emp_fed_tax_rule_id = p_emp_fed_tax_rule_id;
2049:
2050: /* Cursor to get the worker's compensation element type */
2051:

Line 2131: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

2127: fetch csr_min_fed_tax_date into l_defaulting_date;
2128: if csr_min_fed_tax_date%notfound then
2129: close csr_min_fed_tax_date;
2130: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
2131: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
2132: hr_utility.raise_error;
2133: end if;
2134: close csr_min_fed_tax_date;
2135: --

Line 2161: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

2157: --
2158: -- No Federal tax rule exists for this id
2159: --
2160: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
2161: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
2162: hr_utility.raise_error;
2163: end if;
2164: close csr_fed_detail;
2165: --

Line 2429: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

2425: --
2426: l_proc varchar2(72) := g_package||'delete_fed_tax_rule';
2427: l_effective_date date;
2428: l_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;
2429: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2430: l_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2431: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2432: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2433: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 2430: l_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

2426: l_proc varchar2(72) := g_package||'delete_fed_tax_rule';
2427: l_effective_date date;
2428: l_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;
2429: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2430: l_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2431: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2432: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2433: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2434: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 2431: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

2427: l_effective_date date;
2428: l_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;
2429: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2430: l_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2431: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2432: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2433: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2434: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2435: l_tmp_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

Line 2432: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

2428: l_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;
2429: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2430: l_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2431: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2432: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2433: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2434: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2435: l_tmp_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2436: --

Line 2433: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

2429: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2430: l_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2431: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2432: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2433: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2434: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2435: l_tmp_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2436: --
2437: l_exit_quietly exception;

Line 2434: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

2430: l_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2431: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2432: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2433: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2434: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2435: l_tmp_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2436: --
2437: l_exit_quietly exception;
2438: --

Line 2435: l_tmp_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

2431: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2432: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2433: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2434: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2435: l_tmp_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2436: --
2437: l_exit_quietly exception;
2438: --
2439: cursor csr_fed_rule is

Line 2441: from pay_us_emp_fed_tax_rules_f fed

2437: l_exit_quietly exception;
2438: --
2439: cursor csr_fed_rule is
2440: select fed.emp_fed_tax_rule_id, fed.object_version_number
2441: from pay_us_emp_fed_tax_rules_f fed
2442: where fed.assignment_id = p_assignment_id
2443: and l_effective_date between fed.effective_start_date
2444: and fed.effective_end_date;
2445: --

Line 2794: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

2790: -- Declare cursors and local variables
2791: --
2792: l_proc varchar2(72) := g_package||'create_default_tax_rules';
2793: l_effective_date date;
2794: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2795: l_fed_effective_start_date
2796: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2797: l_fed_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2798: l_fed_object_version_number

Line 2796: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

2792: l_proc varchar2(72) := g_package||'create_default_tax_rules';
2793: l_effective_date date;
2794: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2795: l_fed_effective_start_date
2796: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2797: l_fed_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2798: l_fed_object_version_number
2799: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2800: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 2797: l_fed_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

2793: l_effective_date date;
2794: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2795: l_fed_effective_start_date
2796: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2797: l_fed_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2798: l_fed_object_version_number
2799: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2800: l_business_group_id per_assignments_f.business_group_id%TYPE;
2801: l_additional_wa_amount

Line 2799: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

2795: l_fed_effective_start_date
2796: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2797: l_fed_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2798: l_fed_object_version_number
2799: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2800: l_business_group_id per_assignments_f.business_group_id%TYPE;
2801: l_additional_wa_amount
2802: pay_us_emp_fed_tax_rules_f.additional_wa_amount%TYPE:='0';
2803: l_filing_status_code

Line 2802: pay_us_emp_fed_tax_rules_f.additional_wa_amount%TYPE:='0';

2798: l_fed_object_version_number
2799: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2800: l_business_group_id per_assignments_f.business_group_id%TYPE;
2801: l_additional_wa_amount
2802: pay_us_emp_fed_tax_rules_f.additional_wa_amount%TYPE:='0';
2803: l_filing_status_code
2804: pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE:='01';
2805: /*
2806: l_eic_filing_status_code

Line 2804: pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE:='01';

2800: l_business_group_id per_assignments_f.business_group_id%TYPE;
2801: l_additional_wa_amount
2802: pay_us_emp_fed_tax_rules_f.additional_wa_amount%TYPE:='0';
2803: l_filing_status_code
2804: pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE:='01';
2805: /*
2806: l_eic_filing_status_code
2807: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE:='3'; No EIC */
2808:

Line 2807: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE:='3'; No EIC */

2803: l_filing_status_code
2804: pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE:='01';
2805: /*
2806: l_eic_filing_status_code
2807: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE:='3'; No EIC */
2808:
2809: l_eic_filing_status_code
2810: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE; /* No EIC */
2811:

Line 2810: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE; /* No EIC */

2806: l_eic_filing_status_code
2807: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE:='3'; No EIC */
2808:
2809: l_eic_filing_status_code
2810: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE; /* No EIC */
2811:
2812: l_fit_override_amount
2813: pay_us_emp_fed_tax_rules_f.fit_override_amount%TYPE:='0';
2814: l_fit_override_rate

Line 2813: pay_us_emp_fed_tax_rules_f.fit_override_amount%TYPE:='0';

2809: l_eic_filing_status_code
2810: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE; /* No EIC */
2811:
2812: l_fit_override_amount
2813: pay_us_emp_fed_tax_rules_f.fit_override_amount%TYPE:='0';
2814: l_fit_override_rate
2815: pay_us_emp_fed_tax_rules_f.fit_override_rate%TYPE:='0';
2816: l_withholding_allowances
2817: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE:='0';

Line 2815: pay_us_emp_fed_tax_rules_f.fit_override_rate%TYPE:='0';

2811:
2812: l_fit_override_amount
2813: pay_us_emp_fed_tax_rules_f.fit_override_amount%TYPE:='0';
2814: l_fit_override_rate
2815: pay_us_emp_fed_tax_rules_f.fit_override_rate%TYPE:='0';
2816: l_withholding_allowances
2817: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE:='0';
2818: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;
2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

Line 2817: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE:='0';

2813: pay_us_emp_fed_tax_rules_f.fit_override_amount%TYPE:='0';
2814: l_fit_override_rate
2815: pay_us_emp_fed_tax_rules_f.fit_override_rate%TYPE:='0';
2816: l_withholding_allowances
2817: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE:='0';
2818: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;
2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;

Line 2818: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;

2814: l_fit_override_rate
2815: pay_us_emp_fed_tax_rules_f.fit_override_rate%TYPE:='0';
2816: l_withholding_allowances
2817: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE:='0';
2818: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;
2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;
2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;

Line 2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

2815: pay_us_emp_fed_tax_rules_f.fit_override_rate%TYPE:='0';
2816: l_withholding_allowances
2817: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE:='0';
2818: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;
2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;
2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;
2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;

Line 2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

2816: l_withholding_allowances
2817: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE:='0';
2818: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;
2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;
2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;
2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;
2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;

Line 2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;

2817: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE:='0';
2818: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;
2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;
2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;
2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;
2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;
2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;

Line 2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;

2818: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;
2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;
2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;
2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;
2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;
2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;
2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;

Line 2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;

2819: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;
2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;
2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;
2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;
2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;
2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;
2827: --

Line 2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;

2820: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;
2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;
2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;
2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;
2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;
2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;
2827: --
2828: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

Line 2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;

2821: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;
2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;
2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;
2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;
2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;
2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;
2827: --
2828: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2829: l_temp_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;

2822: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;
2823: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;
2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;
2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;
2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;
2827: --
2828: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2829: l_temp_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2830: l_temp_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 2828: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

2824: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;
2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;
2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;
2827: --
2828: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2829: l_temp_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2830: l_temp_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2831: l_temp_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2832: --

Line 2829: l_temp_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

2825: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;
2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;
2827: --
2828: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2829: l_temp_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2830: l_temp_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2831: l_temp_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2832: --
2833: l_default_flag varchar2(1) := 'Y';

Line 2830: l_temp_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

2826: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;
2827: --
2828: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2829: l_temp_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2830: l_temp_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2831: l_temp_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2832: --
2833: l_default_flag varchar2(1) := 'Y';
2834: l_asg_min_start_date per_assignments_f.effective_start_date%TYPE;

Line 2831: l_temp_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

2827: --
2828: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
2829: l_temp_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2830: l_temp_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2831: l_temp_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2832: --
2833: l_default_flag varchar2(1) := 'Y';
2834: l_asg_min_start_date per_assignments_f.effective_start_date%TYPE;
2835: l_adr_min_start_date per_addresses.date_from%TYPE;

Line 3310: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

3306: l_counter number := 0;
3307: l_effective_date date;
3308: l_assignment_id per_assignments_f.assignment_id%TYPE;
3309: l_location_id per_assignments_f.location_id%TYPE;
3310: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3311: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3312: l_fed_object_version_number
3313: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3314: l_fed_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 3311: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

3307: l_effective_date date;
3308: l_assignment_id per_assignments_f.assignment_id%TYPE;
3309: l_location_id per_assignments_f.location_id%TYPE;
3310: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3311: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3312: l_fed_object_version_number
3313: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3314: l_fed_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3315: l_fed_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 3313: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

3309: l_location_id per_assignments_f.location_id%TYPE;
3310: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3311: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3312: l_fed_object_version_number
3313: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3314: l_fed_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3315: l_fed_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3316: l_tax_location_id hr_locations.location_id%TYPE;
3317: l_tax_loc_state_code pay_us_states.state_code%TYPE;

Line 3314: l_fed_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

3310: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3311: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3312: l_fed_object_version_number
3313: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3314: l_fed_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3315: l_fed_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3316: l_tax_location_id hr_locations.location_id%TYPE;
3317: l_tax_loc_state_code pay_us_states.state_code%TYPE;
3318: l_tax_loc_county_code pay_us_counties.county_code%TYPE;

Line 3315: l_fed_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

3311: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3312: l_fed_object_version_number
3313: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3314: l_fed_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3315: l_fed_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3316: l_tax_location_id hr_locations.location_id%TYPE;
3317: l_tax_loc_state_code pay_us_states.state_code%TYPE;
3318: l_tax_loc_county_code pay_us_counties.county_code%TYPE;
3319: l_tax_loc_city_code pay_us_city_names.city_code%TYPE;

Line 3644: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

3640: l_proc varchar2(72) := g_package||'location_change';
3641: l_effective_date date;
3642: l_temp_char varchar2(10);
3643: l_default_flag varchar2(1) := 'Y';
3644: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3645: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3646: l_assignment_id per_assignments_f.assignment_id%TYPE;
3647: l_business_group_id per_assignments_f.business_group_id%TYPE;
3648: l_location_id per_assignments_f.location_id%TYPE;

Line 3645: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

3641: l_effective_date date;
3642: l_temp_char varchar2(10);
3643: l_default_flag varchar2(1) := 'Y';
3644: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3645: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3646: l_assignment_id per_assignments_f.assignment_id%TYPE;
3647: l_business_group_id per_assignments_f.business_group_id%TYPE;
3648: l_location_id per_assignments_f.location_id%TYPE;
3649: l_loc_id per_assignments_f.location_id%TYPE;

Line 3659: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;

3655: l_loc_county_code pay_us_counties.county_code%TYPE;
3656: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3657: l_loc_city_code pay_us_city_names.city_code%TYPE;
3658: l_loc_ovrd_city_code pay_us_city_names.city_name%TYPE;
3659: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;
3660: l_csr_state_code pay_us_states.state_code%TYPE;
3661: l_csr_county_code pay_us_counties.county_code%TYPE;
3662: l_csr_city_code pay_us_city_names.city_code%TYPE;
3663:

Line 3665: l_pct_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

3661: l_csr_county_code pay_us_counties.county_code%TYPE;
3662: l_csr_city_code pay_us_city_names.city_code%TYPE;
3663:
3664: l_dt_mode varchar2(25);
3665: l_pct_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3666: l_pct_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3667: l_city_pct number;
3668: --
3669: l_fed_rec pay_fed_shd.g_rec_type;

Line 3666: l_pct_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

3662: l_csr_city_code pay_us_city_names.city_code%TYPE;
3663:
3664: l_dt_mode varchar2(25);
3665: l_pct_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3666: l_pct_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3667: l_city_pct number;
3668: --
3669: l_fed_rec pay_fed_shd.g_rec_type;
3670: l_fed_rec_dup pay_fed_shd.g_rec_type;

Line 3681: from pay_us_emp_fed_tax_rules_f

3677: l_exit_quietly exception;
3678: --
3679: cursor csr_fed_tax_dates is
3680: select min(effective_start_date), max(effective_end_date)
3681: from pay_us_emp_fed_tax_rules_f
3682: where assignment_id = p_assignment_id;
3683: --
3684: cursor csr_asg_data is
3685: select asg.location_id, asg.effective_start_date, asg.effective_end_date

Line 3786: from pay_us_emp_fed_tax_rules_f

3782: ,fed_information27
3783: ,fed_information28
3784: ,fed_information29
3785: ,fed_information30
3786: from pay_us_emp_fed_tax_rules_f
3787: where assignment_id = l_csr_assignment_id
3788: and effective_end_date >= l_csr_start_date
3789: and effective_start_date <= l_csr_end_date;
3790: --

Line 3881: from pay_us_emp_fed_tax_rules_f

3877: ,fed_information27
3878: ,fed_information28
3879: ,fed_information29
3880: ,fed_information30
3881: from pay_us_emp_fed_tax_rules_f
3882: where assignment_id = l_csr_assignment_id
3883: and effective_start_date between l_csr_start_date and l_csr_end_date;
3884: --
3885: cursor csr_sta_rec1(l_csr_assignment_id number

Line 4179: from pay_us_emp_fed_tax_rules_f fed

4175: where cty.assignment_id = p_assignment_id;
4176: --
4177: cursor csr_fed_rule_exists(l_csr_tmp_date in date) is
4178: select null
4179: from pay_us_emp_fed_tax_rules_f fed
4180: where fed.assignment_id = p_assignment_id
4181: and fed.effective_start_date = l_csr_tmp_date;
4182: --
4183: begin

Line 4272: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

4268: fetch csr_fed_tax_dates into l_defaulting_date, l_fed_tax_end_date;
4269: close csr_fed_tax_dates;
4270: if l_chg_effective_start_date < l_defaulting_date then
4271: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4272: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4273: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4274: hr_utility.raise_error;
4275: end if;
4276: --

Line 4315: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

4311: if csr_fed_rec1%notfound then
4312: -- No federal tax rule exists as of the end of the assignment record!
4313: close csr_fed_rec1;
4314: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4315: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4316: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_end_date);
4317: hr_utility.raise_error;
4318: end if;
4319: close csr_fed_rec1;

Line 4354: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

4350: if csr_fed_rec1%notfound then
4351: -- No federal tax rule exists as of the start of the assignment record!
4352: close csr_fed_rec1;
4353: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4354: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4355: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4356: hr_utility.raise_error;
4357: end if;
4358: close csr_fed_rec1;

Line 4528: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

4524: if csr_fed_rec1%notfound then
4525: -- No federal tax rule exists as of the start of the assignment record!
4526: close csr_fed_rec1;
4527: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4528: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4529: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4530: hr_utility.raise_error;
4531: end if;
4532: close csr_fed_rec1;

Line 4701: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

4697: if csr_fed_rec1%notfound then
4698: -- No federal tax rule exists as of the end of the assignment record!
4699: close csr_fed_rec1;
4700: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4701: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4702: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_end_date);
4703: hr_utility.raise_error;
4704: end if;
4705: close csr_fed_rec1;

Line 4740: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

4736: if csr_fed_rec1%notfound then
4737: -- No federal tax rule exists as of the start of the assignment record!
4738: close csr_fed_rec1;
4739: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4740: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4741: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4742: hr_utility.raise_error;
4743: end if;
4744: close csr_fed_rec1;

Line 4914: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');

4910: if csr_fed_rec1%notfound then
4911: -- No federal tax rule exists as of the start of the assignment record!
4912: close csr_fed_rec1;
4913: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4914: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4915: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4916: hr_utility.raise_error;
4917: end if;
4918: close csr_fed_rec1;

Line 5223: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

5219: l_tmp_loc_id hr_locations.location_id%TYPE;
5220: l_new_location_id hr_locations.location_id%TYPE;
5221: l_temp_char varchar2(10);
5222: l_tmp_effective_start_date
5223: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5224: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5225: l_tmp_object_version_number
5226: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5227: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

Line 5224: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

5220: l_new_location_id hr_locations.location_id%TYPE;
5221: l_temp_char varchar2(10);
5222: l_tmp_effective_start_date
5223: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5224: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5225: l_tmp_object_version_number
5226: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5227: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5228: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 5226: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

5222: l_tmp_effective_start_date
5223: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5224: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5225: l_tmp_object_version_number
5226: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5227: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5228: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5229: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5230: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 5227: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

5223: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5224: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5225: l_tmp_object_version_number
5226: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5227: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5228: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5229: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5230: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5231: l_default_flag varchar2(1) := 'Y';

Line 5228: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

5224: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5225: l_tmp_object_version_number
5226: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5227: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5228: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5229: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5230: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5231: l_default_flag varchar2(1) := 'Y';
5232: l_defaulting_met boolean;

Line 5229: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

5225: l_tmp_object_version_number
5226: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5227: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5228: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5229: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5230: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5231: l_default_flag varchar2(1) := 'Y';
5232: l_defaulting_met boolean;
5233: l_asg_eed per_assignments_f.effective_end_date%TYPE;

Line 5230: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

5226: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5227: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5228: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5229: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5230: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5231: l_default_flag varchar2(1) := 'Y';
5232: l_defaulting_met boolean;
5233: l_asg_eed per_assignments_f.effective_end_date%TYPE;
5234: l_asg_esd per_assignments_f.effective_start_date%TYPE;

Line 5278: from pay_us_emp_fed_tax_rules_f

5274: --
5275: cursor csr_fed_tax_rule is
5276: select min(effective_start_date), min(effective_end_date),
5277: emp_fed_tax_rule_id
5278: from pay_us_emp_fed_tax_rules_f
5279: where assignment_id = p_assignment_id
5280: group by emp_fed_tax_rule_id;
5281: --
5282: cursor csr_asg_data(p_csr_asg_id number, p_csr_eff_date date) is

Line 5305: from pay_us_emp_fed_tax_rules_f fed

5301: and p_date between asg.effective_start_date and asg.effective_end_date;
5302: --
5303: cursor csr_future_fed_rule(l_csr_date date default hr_api.g_date) is
5304: select null
5305: from pay_us_emp_fed_tax_rules_f fed
5306: where fed.assignment_id = p_assignment_id
5307: and fed.effective_start_date > l_csr_date;
5308: --
5309: cursor csr_fed_rec(l_csr_assignment_id number

Line 5398: from pay_us_emp_fed_tax_rules_f

5394: ,fed_information27
5395: ,fed_information28
5396: ,fed_information29
5397: ,fed_information30
5398: from pay_us_emp_fed_tax_rules_f
5399: where assignment_id = l_csr_assignment_id
5400: and l_csr_effective_date between effective_start_date
5401: and effective_end_date;
5402: --

Line 5492: from pay_us_emp_fed_tax_rules_f

5488: ,fed_information27
5489: ,fed_information28
5490: ,fed_information29
5491: ,fed_information30
5492: from pay_us_emp_fed_tax_rules_f
5493: where assignment_id = l_csr_assignment_id
5494: and l_csr_effective_date <= effective_end_date
5495: order by effective_start_date;
5496: --

Line 5785: update pay_us_emp_fed_tax_rules_f

5781: l_county_rec pay_cnt_shd.g_rec_type;
5782: l_city_rec pay_cty_shd.g_rec_type;
5783:
5784: begin
5785: update pay_us_emp_fed_tax_rules_f
5786: set effective_start_date = p_new_default_date
5787: where assignment_id = p_assignment_id
5788: and effective_start_date = p_defaulting_date;
5789: --

Line 6107: delete from pay_us_emp_fed_tax_rules_f

6103: close csr_future_fed_rule;
6104: end if;
6105: close csr_fed_rec;
6106:
6107: delete from pay_us_emp_fed_tax_rules_f
6108: where assignment_id = p_assignment_id
6109: and effective_start_date < p_new_default_date;
6110:
6111: maintain_wc(

Line 6517: update pay_us_emp_fed_tax_rules_f

6513: if l_new_location_id is not null then
6514: --
6515: -- Pull back start date of federal tax rule and workers comp entry.
6516: --
6517: update pay_us_emp_fed_tax_rules_f
6518: set effective_start_date = l_new_default_date
6519: where assignment_id = p_assignment_id
6520: and effective_start_date = l_defaulting_date;
6521: --

Line 6829: update pay_us_emp_fed_tax_rules_f

6825: --
6826: -- Pull back the start date of the federal tax rule and the workers
6827: -- comp element entry.
6828: --
6829: update pay_us_emp_fed_tax_rules_f
6830: set effective_start_date = l_new_default_date
6831: where assignment_id = p_assignment_id
6832: and effective_start_date = l_defaulting_date;
6833: --