DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on BEN_ACTL_PREM_F

Line 1854: from ben_actl_prem_f apr

1850: l_actl_prem_id number;
1851: begin
1852: select apr.actl_prem_id
1853: into l_actl_prem_id
1854: from ben_actl_prem_f apr
1855: where apr.name = p_actual_premium
1856: and apr.business_group_id + 0 = p_business_group_id
1857: and p_effective_date between
1858: apr.effective_start_date and apr.effective_end_date;

Line 1876: from ben_actl_prem_f apr

1872: l_ovn number;
1873: begin
1874: select apr.object_version_number
1875: into l_ovn
1876: from ben_actl_prem_f apr
1877: where apr.name = p_actual_premium
1878: and apr.business_group_id + 0 = p_business_group_id
1879: and p_effective_date between
1880: apr.effective_start_date and apr.effective_end_date;