DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 3831: from pay_us_emp_state_tax_rules_f rules,

3827: l_ovn number;
3828: begin
3829: select rules.object_version_number
3830: into l_ovn
3831: from pay_us_emp_state_tax_rules_f rules,
3832: hr_pump_batch_line_user_keys key
3833: where key.user_key_value = p_emp_state_tax_rule_user_key
3834: and rules.emp_state_tax_rule_id = key.unique_key_id
3835: and p_effective_date between

Line 4934: from pay_us_emp_state_tax_rules_f puek,

4930: l_ovn number;
4931: begin
4932: select object_version_number
4933: into l_ovn
4934: from pay_us_emp_state_tax_rules_f puek,
4935: hr_pump_batch_line_user_keys uk
4936: where uk.user_key_value = p_emp_state_tax_rule_user_key
4937: and p_effective_date between puek.effective_start_date and puek.effective_end_date
4938: and puek.emp_state_tax_rule_id = uk.unique_key_id;