DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on BEN_LER_F

Line 1766: from ben_ler_f ler

1762: l_ler_id number;
1763: begin
1764: select ler.ler_id
1765: into l_ler_id
1766: from ben_ler_f ler
1767: where ler.name = p_life_event_reason
1768: and ler.business_group_id + 0 = p_business_group_id
1769: and p_effective_date between
1770: ler.effective_start_date and ler.effective_end_date;

Line 1788: from ben_ler_f ler

1784: l_ovn number;
1785: begin
1786: select ler.object_version_number
1787: into l_ovn
1788: from ben_ler_f ler
1789: where ler.name = p_life_event_reason
1790: and ler.business_group_id + 0 = p_business_group_id
1791: and p_effective_date between
1792: ler.effective_start_date and ler.effective_end_date;