[Home] [Help]
3830: l_ovn number;
3831: begin
3832: select rules.object_version_number
3833: into l_ovn
3834: from pay_us_emp_fed_tax_rules_f rules,
3835: hr_pump_batch_line_user_keys key
3836: where key.user_key_value = p_emp_fed_tax_rule_user_key
3837: and rules.emp_fed_tax_rule_id = key.unique_key_id
3838: and p_effective_date between
4928: l_ovn number;
4929: begin
4930: select object_version_number
4931: into l_ovn
4932: from pay_us_emp_fed_tax_rules_f puek,
4933: hr_pump_batch_line_user_keys uk
4934: where uk.user_key_value = p_emp_fed_tax_rule_user_key
4935: and p_effective_date between puek.effective_start_date and puek.effective_end_date
4936: and puek.emp_fed_tax_rule_id = uk.unique_key_id;