DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 3906: from pay_us_emp_city_tax_rules_f rules,

3902: l_ovn number;
3903: begin
3904: select rules.object_version_number
3905: into l_ovn
3906: from pay_us_emp_city_tax_rules_f rules,
3907: hr_pump_batch_line_user_keys key
3908: where key.user_key_value = p_emp_city_tax_rule_user_key
3909: and rules.emp_city_tax_rule_id = key.unique_key_id
3910: and p_effective_date between

Line 5014: from pay_us_emp_city_tax_rules_f puek,

5010: l_ovn number;
5011: begin
5012: select object_version_number
5013: into l_ovn
5014: from pay_us_emp_city_tax_rules_f puek,
5015: hr_pump_batch_line_user_keys uk
5016: where uk.user_key_value = p_emp_city_tax_rule_user_key
5017: and p_effective_date between puek.effective_start_date and puek.effective_end_date
5018: and puek.emp_city_tax_rule_id = uk.unique_key_id;