DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on BEN_PL_F

Line 2024: from ben_pl_f pln

2020: l_pl_id number;
2021: begin
2022: select pln.pl_id
2023: into l_pl_id
2024: from ben_pl_f pln
2025: where pln.name = p_plan
2026: and pln.business_group_id + 0 = p_business_group_id
2027: and p_effective_date between
2028: pln.effective_start_date and pln.effective_end_date;

Line 2046: from ben_pl_f pln

2042: l_ovn number;
2043: begin
2044: select pln.object_version_number
2045: into l_ovn
2046: from ben_pl_f pln
2047: where pln.name = p_plan
2048: and pln.business_group_id + 0 = p_business_group_id
2049: and p_effective_date between
2050: pln.effective_start_date and pln.effective_end_date;