DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 3879: from pay_us_emp_city_tax_rules_f rules,

3875: l_ovn number;
3876: begin
3877: select rules.object_version_number
3878: into l_ovn
3879: from pay_us_emp_city_tax_rules_f rules,
3880: hr_pump_batch_line_user_keys key
3881: where key.user_key_value = p_emp_city_tax_rule_user_key
3882: and rules.emp_city_tax_rule_id = key.unique_key_id
3883: and p_effective_date between

Line 4987: from pay_us_emp_city_tax_rules_f puek,

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