DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 3882: from pay_us_emp_county_tax_rules_f rules,

3878: l_ovn number;
3879: begin
3880: select rules.object_version_number
3881: into l_ovn
3882: from pay_us_emp_county_tax_rules_f rules,
3883: hr_pump_batch_line_user_keys key
3884: where key.user_key_value = p_emp_county_tax_rule_user_key
3885: and rules.emp_county_tax_rule_id = key.unique_key_id
3886: and p_effective_date between

Line 4987: from pay_us_emp_county_tax_rules_f puek,

4983: l_ovn number;
4984: begin
4985: select object_version_number
4986: into l_ovn
4987: from pay_us_emp_county_tax_rules_f puek,
4988: hr_pump_batch_line_user_keys uk
4989: where uk.user_key_value = p_emp_county_tax_rule_user_key
4990: and p_effective_date between puek.effective_start_date and puek.effective_end_date
4991: and puek.emp_county_tax_rule_id = uk.unique_key_id;