APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_PL_F

Line 416: ben_pl_f pln,

412: -- FONM
413: cursor c_apr2(cv_effective_date date) is
414: select apr.actl_prem_id
415: from ben_actl_prem_f apr,
416: ben_pl_f pln,
417: ben_oipl_f cop
418: where ((pln.pl_id = l_epe.pl_id
419: and pln.actl_prem_id = apr.actl_prem_id
420: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 435: from ben_pl_f pln

431: --
432: -- FONM
433: cursor c_pln(cv_effective_date date) is
434: select pln.nip_acty_ref_perd_cd
435: from ben_pl_f pln
436: where pln.pl_id = l_epe.pl_id
437: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
438: between pln.effective_start_date
439: and pln.effective_end_date;

Line 501: from ben_pl_f pln

497: --
498: -- FONM
499: cursor c_imp_inc_plan(p_pl_id in number, cv_effective_date date) is
500: select 'Y'
501: from ben_pl_f pln
502: where pln.imptd_incm_calc_cd in ('PRTT', 'SPS', 'DPNT') and
503: pln.pl_stat_cd = 'A' and
504: pln.pl_id = p_pl_id and
505: pln.business_group_id = p_business_group_id and