DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PL_TYP_OPT_TYP_F

Line 8073: , ben_pl_typ_opt_typ_f pto

8069: cp_effective_date in date ,
8070: cp_business_group_id in number) is
8071: select null
8072: from ben_prtt_enrt_rslt_f pen
8073: , ben_pl_typ_opt_typ_f pto
8074: where pto.pl_typ_opt_typ_id = cp_pl_typ_opt_typ_id
8075: and pto.business_group_id = cp_business_group_id
8076: and nvl(cp_lf_evt_ocrd_dt,cp_effective_date)
8077: between pto.effective_start_date and pto.effective_end_date