DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on BEN_ACTY_BASE_RT_F

Line 1810: from ben_acty_base_rt_f abr

1806: l_acty_base_rt_id number;
1807: begin
1808: select abr.acty_base_rt_id
1809: into l_acty_base_rt_id
1810: from ben_acty_base_rt_f abr
1811: where abr.name = p_acty_base_rate
1812: and abr.business_group_id + 0 = p_business_group_id
1813: and p_effective_date between
1814: abr.effective_start_date and abr.effective_end_date;

Line 1832: from ben_acty_base_rt_f abr

1828: l_ovn number;
1829: begin
1830: select abr.object_version_number
1831: into l_ovn
1832: from ben_acty_base_rt_f abr
1833: where abr.name = p_acty_base_rate
1834: and abr.business_group_id + 0 = p_business_group_id
1835: and p_effective_date between
1836: abr.effective_start_date and abr.effective_end_date;