APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_PL_F

Line 450: ben_pl_f pln,

446: -- FONM
447: cursor c_apr2(cv_effective_date date) is
448: select apr.actl_prem_id
449: from ben_actl_prem_f apr,
450: ben_pl_f pln,
451: ben_oipl_f cop
452: where ((pln.pl_id = l_epe.pl_id
453: and pln.actl_prem_id = apr.actl_prem_id
454: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 469: from ben_pl_f pln

465: --
466: -- FONM
467: cursor c_pln(cv_effective_date date) is
468: select pln.nip_acty_ref_perd_cd
469: from ben_pl_f pln
470: where pln.pl_id = l_epe.pl_id
471: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
472: between pln.effective_start_date
473: and pln.effective_end_date;

Line 535: from ben_pl_f pln

531: --
532: -- FONM
533: cursor c_imp_inc_plan(p_pl_id in number, cv_effective_date date) is
534: select 'Y'
535: from ben_pl_f pln
536: where pln.imptd_incm_calc_cd in ('PRTT', 'SPS', 'DPNT') and
537: pln.pl_stat_cd = 'A' and
538: pln.pl_id = p_pl_id and
539: pln.business_group_id = p_business_group_id and