APPS.BEN_DETERMINE_ELIGIBILITY dependencies on BEN_PLIP_F
Line 168: from ben_plip_f plip,
164: and effective_end_date;
165: --
166: cursor c_plip_pl_typ(c_effective_date date) is
167: select pln.pl_typ_id 168: from ben_plip_f plip, 169: ben_pl_f pln
170: where plip_id = p_plip_id
171: and c_effective_date
172: between plip.effective_start_date and plip.effective_end_date