DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 3855: from pay_us_emp_county_tax_rules_f rules,

3851: l_ovn number;
3852: begin
3853: select rules.object_version_number
3854: into l_ovn
3855: from pay_us_emp_county_tax_rules_f rules,
3856: hr_pump_batch_line_user_keys key
3857: where key.user_key_value = p_emp_county_tax_rule_user_key
3858: and rules.emp_county_tax_rule_id = key.unique_key_id
3859: and p_effective_date between

Line 4960: from pay_us_emp_county_tax_rules_f puek,

4956: l_ovn number;
4957: begin
4958: select object_version_number
4959: into l_ovn
4960: from pay_us_emp_county_tax_rules_f puek,
4961: hr_pump_batch_line_user_keys uk
4962: where uk.user_key_value = p_emp_county_tax_rule_user_key
4963: and p_effective_date between puek.effective_start_date and puek.effective_end_date
4964: and puek.emp_county_tax_rule_id = uk.unique_key_id;