DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PL_TYP_OPT_TYP_F

Line 8055: , ben_pl_typ_opt_typ_f pto

8051: cp_effective_date in date ,
8052: cp_business_group_id in number) is
8053: select null
8054: from ben_prtt_enrt_rslt_f pen
8055: , ben_pl_typ_opt_typ_f pto
8056: where pto.pl_typ_opt_typ_id = cp_pl_typ_opt_typ_id
8057: and pto.business_group_id = cp_business_group_id
8058: and nvl(cp_lf_evt_ocrd_dt,cp_effective_date)
8059: between pto.effective_start_date and pto.effective_end_date