APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on BEN_PL_TYP_OPT_TYP_F

Line 349: ben_pl_typ_opt_typ_f pto, ben_pl_typ_f ptp, ben_opt_f opt

345: /* mapping not required
346: select
347: ptp.name || ' - ' || opt.name name into l_name
348: from
349: ben_pl_typ_opt_typ_f pto, ben_pl_typ_f ptp, ben_opt_f opt
350: where
351: pto.business_group_id = l_business_group_id
352: and pto.pl_typ_opt_typ_id = l_crit.information228
353: and p_effective_date between pto.effective_start_date and pto.effective_end_date

Line 365: ben_pl_typ_opt_typ_f pto, ben_oipl_f oipl, ben_pl_f pln

361:
362: select
363: pln.name name into l_information185
364: from
365: ben_pl_typ_opt_typ_f pto, ben_oipl_f oipl, ben_pl_f pln
366: where
367: pto.business_group_id = l_business_group_id
368: and p_effective_date between pto.effective_start_date and pto.effective_end_date
369: and oipl.oipl_id = l_crit.information258