DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 3807: from pay_us_emp_fed_tax_rules_f rules,

3803: l_ovn number;
3804: begin
3805: select rules.object_version_number
3806: into l_ovn
3807: from pay_us_emp_fed_tax_rules_f rules,
3808: hr_pump_batch_line_user_keys key
3809: where key.user_key_value = p_emp_fed_tax_rule_user_key
3810: and rules.emp_fed_tax_rule_id = key.unique_key_id
3811: and p_effective_date between

Line 4905: from pay_us_emp_fed_tax_rules_f puek,

4901: l_ovn number;
4902: begin
4903: select object_version_number
4904: into l_ovn
4905: from pay_us_emp_fed_tax_rules_f puek,
4906: hr_pump_batch_line_user_keys uk
4907: where uk.user_key_value = p_emp_fed_tax_rule_user_key
4908: and p_effective_date between puek.effective_start_date and puek.effective_end_date
4909: and puek.emp_fed_tax_rule_id = uk.unique_key_id;