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 2004: l_assignment_id pay_us_emp_fed_tax_rules_f.assignment_id%TYPE;

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

Line 2005: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;

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

Line 2017: l_wc_min_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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

Line 2018: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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

Line 2032: from pay_us_emp_fed_tax_rules_f fed

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

Line 2041: from pay_us_emp_fed_tax_rules_f fed

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

Line 2049: from pay_us_emp_fed_tax_rules_f

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

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

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

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

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

Line 2431: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

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

Line 2432: l_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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

Line 2433: l_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

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

Line 2434: l_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

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

Line 2435: l_tmp_effective_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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

Line 2436: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

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

Line 2437: l_tmp_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

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

Line 2443: from pay_us_emp_fed_tax_rules_f fed

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

Line 2796: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

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

Line 2798: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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

Line 2799: l_fed_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

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

Line 2801: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2820: l_cumulative_taxation pay_us_emp_fed_tax_rules_f.cumulative_taxation%TYPE;

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

Line 2821: l_fit_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

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

Line 2822: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

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

Line 2823: l_futa_tax_exempt pay_us_emp_fed_tax_rules_f.futa_tax_exempt%TYPE;

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

Line 2824: l_medicare_tax_exempt pay_us_emp_fed_tax_rules_f.medicare_tax_exempt%TYPE;

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

Line 2825: l_ss_tax_exempt pay_us_emp_fed_tax_rules_f.ss_tax_exempt%TYPE;

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

Line 2826: l_wage_exempt pay_us_emp_fed_tax_rules_f.wage_exempt%TYPE;

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

Line 2827: l_statutory_employee pay_us_emp_fed_tax_rules_f.statutory_employee%TYPE;

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

Line 2828: l_supp_tax_override_rate pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE;

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

Line 2830: l_temp_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

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

Line 2831: l_temp_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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

Line 2832: l_temp_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

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

Line 2833: l_temp_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

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

Line 3312: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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

Line 3313: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

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

Line 3315: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

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

Line 3316: l_fed_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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

Line 3317: l_fed_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

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

Line 3728: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

3724: l_proc varchar2(72) := g_package||'location_change';
3725: l_effective_date date;
3726: l_temp_char varchar2(10);
3727: l_default_flag varchar2(1) := 'Y';
3728: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3729: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3730: l_assignment_id per_assignments_f.assignment_id%TYPE;
3731: l_business_group_id per_assignments_f.business_group_id%TYPE;
3732: l_location_id per_assignments_f.location_id%TYPE;

Line 3729: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

3725: l_effective_date date;
3726: l_temp_char varchar2(10);
3727: l_default_flag varchar2(1) := 'Y';
3728: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3729: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3730: l_assignment_id per_assignments_f.assignment_id%TYPE;
3731: l_business_group_id per_assignments_f.business_group_id%TYPE;
3732: l_location_id per_assignments_f.location_id%TYPE;
3733: l_loc_id per_assignments_f.location_id%TYPE;

Line 3743: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;

3739: l_loc_county_code pay_us_counties.county_code%TYPE;
3740: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3741: l_loc_city_code pay_us_city_names.city_code%TYPE;
3742: l_loc_ovrd_city_code pay_us_city_names.city_name%TYPE;
3743: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;
3744: l_csr_state_code pay_us_states.state_code%TYPE;
3745: l_csr_county_code pay_us_counties.county_code%TYPE;
3746: l_csr_city_code pay_us_city_names.city_code%TYPE;
3747:

Line 3749: l_pct_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

3745: l_csr_county_code pay_us_counties.county_code%TYPE;
3746: l_csr_city_code pay_us_city_names.city_code%TYPE;
3747:
3748: l_dt_mode varchar2(25);
3749: l_pct_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3750: l_pct_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3751: l_city_pct number;
3752: --
3753: l_fed_rec pay_fed_shd.g_rec_type;

Line 3750: l_pct_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

3746: l_csr_city_code pay_us_city_names.city_code%TYPE;
3747:
3748: l_dt_mode varchar2(25);
3749: l_pct_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3750: l_pct_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3751: l_city_pct number;
3752: --
3753: l_fed_rec pay_fed_shd.g_rec_type;
3754: l_fed_rec_dup pay_fed_shd.g_rec_type;

Line 3765: from pay_us_emp_fed_tax_rules_f

3761: l_exit_quietly exception;
3762: --
3763: cursor csr_fed_tax_dates is
3764: select min(effective_start_date), max(effective_end_date)
3765: from pay_us_emp_fed_tax_rules_f
3766: where assignment_id = p_assignment_id;
3767: --
3768: cursor csr_asg_data is
3769: select asg.location_id, asg.effective_start_date, asg.effective_end_date

Line 3870: from pay_us_emp_fed_tax_rules_f

3866: ,fed_information27
3867: ,fed_information28
3868: ,fed_information29
3869: ,fed_information30
3870: from pay_us_emp_fed_tax_rules_f
3871: where assignment_id = l_csr_assignment_id
3872: and effective_end_date >= l_csr_start_date
3873: and effective_start_date <= l_csr_end_date;
3874: --

Line 3965: from pay_us_emp_fed_tax_rules_f

3961: ,fed_information27
3962: ,fed_information28
3963: ,fed_information29
3964: ,fed_information30
3965: from pay_us_emp_fed_tax_rules_f
3966: where assignment_id = l_csr_assignment_id
3967: and effective_start_date between l_csr_start_date and l_csr_end_date;
3968: --
3969: cursor csr_sta_rec1(l_csr_assignment_id number

Line 4263: from pay_us_emp_fed_tax_rules_f fed

4259: where cty.assignment_id = p_assignment_id;
4260: --
4261: cursor csr_fed_rule_exists(l_csr_tmp_date in date) is
4262: select null
4263: from pay_us_emp_fed_tax_rules_f fed
4264: where fed.assignment_id = p_assignment_id
4265: and fed.effective_start_date = l_csr_tmp_date;
4266: --
4267: begin

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

4352: fetch csr_fed_tax_dates into l_defaulting_date, l_fed_tax_end_date;
4353: close csr_fed_tax_dates;
4354: if l_chg_effective_start_date < l_defaulting_date then
4355: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4356: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4357: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4358: hr_utility.raise_error;
4359: end if;
4360: --

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

4395: if csr_fed_rec1%notfound then
4396: -- No federal tax rule exists as of the end of the assignment record!
4397: close csr_fed_rec1;
4398: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4399: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4400: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_end_date);
4401: hr_utility.raise_error;
4402: end if;
4403: close csr_fed_rec1;

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

4434: if csr_fed_rec1%notfound then
4435: -- No federal tax rule exists as of the start of the assignment record!
4436: close csr_fed_rec1;
4437: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4438: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4439: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4440: hr_utility.raise_error;
4441: end if;
4442: close csr_fed_rec1;

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

4608: if csr_fed_rec1%notfound then
4609: -- No federal tax rule exists as of the start of the assignment record!
4610: close csr_fed_rec1;
4611: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4612: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4613: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4614: hr_utility.raise_error;
4615: end if;
4616: close csr_fed_rec1;

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

4781: if csr_fed_rec1%notfound then
4782: -- No federal tax rule exists as of the end of the assignment record!
4783: close csr_fed_rec1;
4784: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4785: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4786: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_end_date);
4787: hr_utility.raise_error;
4788: end if;
4789: close csr_fed_rec1;

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

4820: if csr_fed_rec1%notfound then
4821: -- No federal tax rule exists as of the start of the assignment record!
4822: close csr_fed_rec1;
4823: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4824: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4825: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
4826: hr_utility.raise_error;
4827: end if;
4828: close csr_fed_rec1;

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

4994: if csr_fed_rec1%notfound then
4995: -- No federal tax rule exists as of the start of the assignment record!
4996: close csr_fed_rec1;
4997: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
4998: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_FED_TAX_RULES_F');
4999: hr_utility.set_message_token('SESSION_DATE', l_chg_effective_start_date);
5000: hr_utility.raise_error;
5001: end if;
5002: close csr_fed_rec1;

Line 5307: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

5303: l_tmp_loc_id hr_locations.location_id%TYPE;
5304: l_new_location_id hr_locations.location_id%TYPE;
5305: l_temp_char varchar2(10);
5306: l_tmp_effective_start_date
5307: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5308: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5309: l_tmp_object_version_number
5310: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5311: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

Line 5308: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

5304: l_new_location_id hr_locations.location_id%TYPE;
5305: l_temp_char varchar2(10);
5306: l_tmp_effective_start_date
5307: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5308: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5309: l_tmp_object_version_number
5310: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5311: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5312: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 5310: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

5306: l_tmp_effective_start_date
5307: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5308: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5309: l_tmp_object_version_number
5310: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5311: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5312: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5313: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5314: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 5311: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

5307: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5308: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5309: l_tmp_object_version_number
5310: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5311: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5312: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5313: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5314: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5315: l_default_flag varchar2(1) := 'Y';

Line 5312: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

5308: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5309: l_tmp_object_version_number
5310: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5311: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5312: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5313: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5314: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5315: l_default_flag varchar2(1) := 'Y';
5316: l_defaulting_met boolean;

Line 5313: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

5309: l_tmp_object_version_number
5310: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5311: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5312: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5313: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5314: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5315: l_default_flag varchar2(1) := 'Y';
5316: l_defaulting_met boolean;
5317: l_asg_eed per_assignments_f.effective_end_date%TYPE;

Line 5314: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

5310: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
5311: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
5312: l_new_default_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5313: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5314: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5315: l_default_flag varchar2(1) := 'Y';
5316: l_defaulting_met boolean;
5317: l_asg_eed per_assignments_f.effective_end_date%TYPE;
5318: l_asg_esd per_assignments_f.effective_start_date%TYPE;

Line 5362: from pay_us_emp_fed_tax_rules_f

5358: --
5359: cursor csr_fed_tax_rule is
5360: select min(effective_start_date), min(effective_end_date),
5361: emp_fed_tax_rule_id
5362: from pay_us_emp_fed_tax_rules_f
5363: where assignment_id = p_assignment_id
5364: group by emp_fed_tax_rule_id;
5365: --
5366: cursor csr_asg_data(p_csr_asg_id number, p_csr_eff_date date) is

Line 5389: from pay_us_emp_fed_tax_rules_f fed

5385: and p_date between asg.effective_start_date and asg.effective_end_date;
5386: --
5387: cursor csr_future_fed_rule(l_csr_date date default hr_api.g_date) is
5388: select null
5389: from pay_us_emp_fed_tax_rules_f fed
5390: where fed.assignment_id = p_assignment_id
5391: and fed.effective_start_date > l_csr_date;
5392: --
5393: cursor csr_fed_rec(l_csr_assignment_id number

Line 5482: from pay_us_emp_fed_tax_rules_f

5478: ,fed_information27
5479: ,fed_information28
5480: ,fed_information29
5481: ,fed_information30
5482: from pay_us_emp_fed_tax_rules_f
5483: where assignment_id = l_csr_assignment_id
5484: and l_csr_effective_date between effective_start_date
5485: and effective_end_date;
5486: --

Line 5576: from pay_us_emp_fed_tax_rules_f

5572: ,fed_information27
5573: ,fed_information28
5574: ,fed_information29
5575: ,fed_information30
5576: from pay_us_emp_fed_tax_rules_f
5577: where assignment_id = l_csr_assignment_id
5578: and l_csr_effective_date <= effective_end_date
5579: order by effective_start_date;
5580: --

Line 5869: update pay_us_emp_fed_tax_rules_f

5865: l_county_rec pay_cnt_shd.g_rec_type;
5866: l_city_rec pay_cty_shd.g_rec_type;
5867:
5868: begin
5869: update pay_us_emp_fed_tax_rules_f
5870: set effective_start_date = p_new_default_date
5871: where assignment_id = p_assignment_id
5872: and effective_start_date = p_defaulting_date;
5873: --

Line 6191: delete from pay_us_emp_fed_tax_rules_f

6187: close csr_future_fed_rule;
6188: end if;
6189: close csr_fed_rec;
6190:
6191: delete from pay_us_emp_fed_tax_rules_f
6192: where assignment_id = p_assignment_id
6193: and effective_start_date < p_new_default_date;
6194:
6195: maintain_wc(

Line 6601: update pay_us_emp_fed_tax_rules_f

6597: if l_new_location_id is not null then
6598: --
6599: -- Pull back start date of federal tax rule and workers comp entry.
6600: --
6601: update pay_us_emp_fed_tax_rules_f
6602: set effective_start_date = l_new_default_date
6603: where assignment_id = p_assignment_id
6604: and effective_start_date = l_defaulting_date;
6605: --

Line 6913: update pay_us_emp_fed_tax_rules_f

6909: --
6910: -- Pull back the start date of the federal tax rule and the workers
6911: -- comp element entry.
6912: --
6913: update pay_us_emp_fed_tax_rules_f
6914: set effective_start_date = l_new_default_date
6915: where assignment_id = p_assignment_id
6916: and effective_start_date = l_defaulting_date;
6917: --