116: --
117: -- Declare cursors and local variables
118: --
119: l_business_group_id per_assignments_f.business_group_id%TYPE;
120: l_defaulting_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
121: l_emp_county_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
122: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
123: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
124: l_proc varchar2(72) := g_package||'create_county_tax_rule';
117: -- Declare cursors and local variables
118: --
119: l_business_group_id per_assignments_f.business_group_id%TYPE;
120: l_defaulting_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
121: l_emp_county_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
122: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
123: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
124: l_proc varchar2(72) := g_package||'create_county_tax_rule';
125: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
118: --
119: l_business_group_id per_assignments_f.business_group_id%TYPE;
120: l_defaulting_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
121: l_emp_county_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
122: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
123: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
124: l_proc varchar2(72) := g_package||'create_county_tax_rule';
125: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
126: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
119: l_business_group_id per_assignments_f.business_group_id%TYPE;
120: l_defaulting_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
121: l_emp_county_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
122: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
123: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
124: l_proc varchar2(72) := g_package||'create_county_tax_rule';
125: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
126: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
127: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
121: l_emp_county_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
122: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
123: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
124: l_proc varchar2(72) := g_package||'create_county_tax_rule';
125: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
126: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
127: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
128: --
129: /** added for bug 13891625**/
122: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
123: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
124: l_proc varchar2(72) := g_package||'create_county_tax_rule';
125: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
126: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
127: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
128: --
129: /** added for bug 13891625**/
130: cursor csr_county_tax_rule is
128: --
129: /** added for bug 13891625**/
130: cursor csr_county_tax_rule is
131: select null
132: from pay_us_emp_county_tax_rules_f sta
133: where sta.assignment_id = p_assignment_id
134: and sta.state_code = p_state_code
135: and sta.county_code= p_county_code;
136:
522: --
523: -- Declare cursors and local variables
524: --
525: l_proc varchar2(72) := g_package||'update_county_tax_rule';
526: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
527: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
528: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
529: l_assignment_id pay_us_emp_county_tax_rules_f.assignment_id%TYPE;
530: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
523: -- Declare cursors and local variables
524: --
525: l_proc varchar2(72) := g_package||'update_county_tax_rule';
526: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
527: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
528: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
529: l_assignment_id pay_us_emp_county_tax_rules_f.assignment_id%TYPE;
530: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
531: --
524: --
525: l_proc varchar2(72) := g_package||'update_county_tax_rule';
526: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
527: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
528: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
529: l_assignment_id pay_us_emp_county_tax_rules_f.assignment_id%TYPE;
530: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
531: --
532: CURSOR csr_assignment_id (p_rule_id NUMBER,
525: l_proc varchar2(72) := g_package||'update_county_tax_rule';
526: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
527: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
528: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
529: l_assignment_id pay_us_emp_county_tax_rules_f.assignment_id%TYPE;
530: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
531: --
532: CURSOR csr_assignment_id (p_rule_id NUMBER,
533: p_eff_date DATE) IS
526: l_object_version_number pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
527: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
528: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
529: l_assignment_id pay_us_emp_county_tax_rules_f.assignment_id%TYPE;
530: l_jurisdiction_code pay_us_emp_county_tax_rules_f.jurisdiction_code%TYPE;
531: --
532: CURSOR csr_assignment_id (p_rule_id NUMBER,
533: p_eff_date DATE) IS
534: SELECT ctr.assignment_id,
532: CURSOR csr_assignment_id (p_rule_id NUMBER,
533: p_eff_date DATE) IS
534: SELECT ctr.assignment_id,
535: ctr.state_code||'-'||ctr.school_district_code
536: FROM pay_us_emp_county_tax_rules_f ctr
537: WHERE ctr.emp_county_tax_rule_id = p_rule_id
538: AND p_eff_date BETWEEN ctr.effective_start_date
539: AND ctr.effective_end_date;
540: --