290: cp_state_abbrev VARCHAR2)
291: IS
292: SELECT pst.emp_state_tax_rule_id,
293: pst.object_version_number
294: FROM pay_us_emp_state_tax_rules_f pst,
295: pay_us_states pus
296: WHERE pst.assignment_id = cp_assignment_id
297: AND cp_effective_date BETWEEN pst.effective_start_date
298: AND pst.effective_end_date
371: lb_tax_dist_changed_warning BOOLEAN;
372:
373: ln_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
374: ln_ft_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
375: ln_emp_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
376: ln_st_object_version_number pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
377:
378: FUNCTION value_changed(p_value VARCHAR2,
379: p_default_value VARCHAR2)
372:
373: ln_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
374: ln_ft_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
375: ln_emp_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
376: ln_st_object_version_number pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
377:
378: FUNCTION value_changed(p_value VARCHAR2,
379: p_default_value VARCHAR2)
380: