APPS.BEN_PUMP_GET dependencies on BEN_PL_F

Line 181: from ben_pl_f pln

177: l_pl_id := p_plan_num ;
178: ELSIF p_plan IS NOT NULL THEN
179: select pln.pl_id
180: into l_pl_id
181: from ben_pl_f pln
182: where pln.name = p_plan
183: and pln.business_group_id + 0 = p_business_group_id
184: and p_effective_date between
185: pln.effective_start_date and pln.effective_end_date;

Line 209: from ben_pl_f pln

205: l_pl_id := p_ended_plan_num ;
206: ELSIF p_ended_plan IS NOT NULL THEN
207: select pln.pl_id
208: into l_pl_id
209: from ben_pl_f pln
210: where pln.name = p_ended_plan
211: and pln.business_group_id + 0 = p_business_group_id
212: and p_effective_date between
213: pln.effective_start_date and pln.effective_end_date;