[Home] [Help]
99: --
100: Cursor get_state_tax_rule_id(l_jurisdiction varchar2) is
101: select emp_state_tax_rule_id, object_version_number,
102: effective_start_date, effective_end_date
103: from pay_us_emp_state_tax_rules_f
104: where assignment_id = p_assignment_id
105: and jurisdiction_code = l_jurisdiction
106: and p_effective_date between effective_start_date
107: and effective_end_date;
162: COUNTY_JURISDICTION constant number := 2;
163: STATE_JURISDICTION constant number := 3;
164:
165: l_proc varchar2(72) := g_package||'delete_tax_rule';
166: l_jurisdiction_code pay_us_emp_state_tax_rules.jurisdiction_code%TYPE;
167: l_object_version_number
168: pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
169: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
170: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
171: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
172: l_emp_county_tax_rule_id
173: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
174: l_emp_state_tax_rule_id
175: pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
176: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
177: t_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
178: l_effective_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
179: l_vertex_exist number;
336: );
337: else
338: close get_state_tax_rule_id;
339: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
340: hr_utility.set_message_token('table', 'pay_us_emp_state_tax_rules_f');
341: hr_utility.set_message_token('step','65');
342: hr_utility.raise_error;
343: end if;
344: end if;
429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
430: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
431: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
432: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
433: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
434: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
435: ln_dummy NUMBER(15);
436: lv_datetrack_mode VARCHAR2(30);
437: lv_update_method VARCHAR2(30);
474: pus.state_code,
475: paf.assignment_id,
476: stif.sta_information7,
477: hsck.segment1
478: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
479: pay_us_state_tax_info_f stif, pay_us_states pus,
480: hr_soft_coding_keyflex hsck
481: where paf.person_id = p_person_id
482: and paf.assignment_id = str.assignment_id
888:
889: CURSOR c_excess_over_state IS
890: select 'x'
891: from per_assignments_f paf,
892: pay_us_emp_state_tax_rules_f str
893: where paf.person_id = p_person_id
894: and paf.assignment_type = 'E'
895: and str.assignment_id = paf.assignment_id
896: and str.state_code = p_state_code
905:
906: CURSOR c_excess_over_state_for_fed IS
907: select 'x'
908: from per_assignments_f paf,
909: pay_us_emp_state_tax_rules_f str,
910: pay_us_state_tax_info_f stif
911: where paf.person_id = p_person_id
912: and paf.assignment_type = 'E'
913: and str.assignment_id = paf.assignment_id
935:
936: CURSOR c_future_state_recs IS
937: select 'x'
938: from per_assignments_f paf,
939: pay_us_emp_state_tax_rules_f str
940: where paf.person_id = p_person_id
941: and str.assignment_id = paf.assignment_id
942: and paf.assignment_type = 'E'
943: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'
948:
949: CURSOR c_future_state_recs_for_fed IS
950: select 'x'
951: from per_assignments_f paf,
952: pay_us_emp_state_tax_rules_f str,
953: pay_us_state_tax_info_f stif
954: where paf.person_id = p_person_id
955: and str.assignment_id = paf.assignment_id
956: and paf.assignment_type = 'E'