[Home] [Help]
3854: l_ovn number;
3855: begin
3856: select rules.object_version_number
3857: into l_ovn
3858: from pay_us_emp_state_tax_rules_f rules,
3859: hr_pump_batch_line_user_keys key
3860: where key.user_key_value = p_emp_state_tax_rule_user_key
3861: and rules.emp_state_tax_rule_id = key.unique_key_id
3862: and p_effective_date between
4957: l_ovn number;
4958: begin
4959: select object_version_number
4960: into l_ovn
4961: from pay_us_emp_state_tax_rules_f puek,
4962: hr_pump_batch_line_user_keys uk
4963: where uk.user_key_value = p_emp_state_tax_rule_user_key
4964: and p_effective_date between puek.effective_start_date and puek.effective_end_date
4965: and puek.emp_state_tax_rule_id = uk.unique_key_id;