113: ,p_cty_information29 in varchar2 default null
114: ,p_cty_information30 in varchar2 default null
115: ) is
116: --
117: l_jurisdiction_code pay_us_emp_city_tax_rules.jurisdiction_code%TYPE;
118: l_business_group_id per_assignments_f.business_group_id%TYPE;
119: l_defaulting_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
120: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
121: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
115: ) is
116: --
117: l_jurisdiction_code pay_us_emp_city_tax_rules.jurisdiction_code%TYPE;
118: l_business_group_id per_assignments_f.business_group_id%TYPE;
119: l_defaulting_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
120: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
121: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
122: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
123: l_proc varchar2(72) := g_package||'create_city_tax_rule';
116: --
117: l_jurisdiction_code pay_us_emp_city_tax_rules.jurisdiction_code%TYPE;
118: l_business_group_id per_assignments_f.business_group_id%TYPE;
119: l_defaulting_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
120: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
121: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
122: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
123: l_proc varchar2(72) := g_package||'create_city_tax_rule';
124: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
117: l_jurisdiction_code pay_us_emp_city_tax_rules.jurisdiction_code%TYPE;
118: l_business_group_id per_assignments_f.business_group_id%TYPE;
119: l_defaulting_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
120: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
121: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
122: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
123: l_proc varchar2(72) := g_package||'create_city_tax_rule';
124: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
118: l_business_group_id per_assignments_f.business_group_id%TYPE;
119: l_defaulting_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
120: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
121: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
122: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
123: l_proc varchar2(72) := g_package||'create_city_tax_rule';
124: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
126: --
120: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
121: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
122: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
123: l_proc varchar2(72) := g_package||'create_city_tax_rule';
124: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
126: --
127:
128: /** added for bug 13872151 **/
127:
128: /** added for bug 13872151 **/
129: cursor csr_city_tax_rule is
130: select null
131: from pay_us_emp_city_tax_rules_f sta
132: where sta.assignment_id = p_assignment_id
133: and sta.state_code = p_state_code
134: and sta.county_code= p_county_code
135: and sta.city_code= p_city_code;
525: --
526: -- Declare cursors and local variables
527: --
528: l_proc varchar2(72) := g_package||'update_city_tax_rule';
529: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
530: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
531: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
532: l_assignment_id pay_us_emp_city_tax_rules_f.assignment_id%TYPE;
533: l_jurisdiction_code pay_us_emp_city_tax_rules_f.jurisdiction_code%TYPE;
526: -- Declare cursors and local variables
527: --
528: l_proc varchar2(72) := g_package||'update_city_tax_rule';
529: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
530: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
531: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
532: l_assignment_id pay_us_emp_city_tax_rules_f.assignment_id%TYPE;
533: l_jurisdiction_code pay_us_emp_city_tax_rules_f.jurisdiction_code%TYPE;
534: --
527: --
528: l_proc varchar2(72) := g_package||'update_city_tax_rule';
529: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
530: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
531: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
532: l_assignment_id pay_us_emp_city_tax_rules_f.assignment_id%TYPE;
533: l_jurisdiction_code pay_us_emp_city_tax_rules_f.jurisdiction_code%TYPE;
534: --
535: CURSOR csr_assignment_id (p_rule_id NUMBER,
528: l_proc varchar2(72) := g_package||'update_city_tax_rule';
529: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
530: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
531: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
532: l_assignment_id pay_us_emp_city_tax_rules_f.assignment_id%TYPE;
533: l_jurisdiction_code pay_us_emp_city_tax_rules_f.jurisdiction_code%TYPE;
534: --
535: CURSOR csr_assignment_id (p_rule_id NUMBER,
536: p_eff_date DATE) IS
529: l_object_version_number pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
530: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
531: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
532: l_assignment_id pay_us_emp_city_tax_rules_f.assignment_id%TYPE;
533: l_jurisdiction_code pay_us_emp_city_tax_rules_f.jurisdiction_code%TYPE;
534: --
535: CURSOR csr_assignment_id (p_rule_id NUMBER,
536: p_eff_date DATE) IS
537: SELECT ctr.assignment_id,
535: CURSOR csr_assignment_id (p_rule_id NUMBER,
536: p_eff_date DATE) IS
537: SELECT ctr.assignment_id,
538: ctr.state_code||'-'||ctr.school_district_code
539: FROM pay_us_emp_city_tax_rules_f ctr
540: WHERE ctr.emp_city_tax_rule_id = p_rule_id
541: AND p_eff_date BETWEEN ctr.effective_start_date
542: AND ctr.effective_end_date;
543: --