APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_PL_F

Line 242: group_pl_id ben_pl_f.pl_id%type,

238: -- table.
239: --
240: type g_cache_copy_person_bdgt_rt is record
241: (person_id ben_cwb_person_rates.person_id%type,
242: group_pl_id ben_pl_f.pl_id%type,
243: group_oipl_id ben_cwb_person_rates.group_oipl_id%type,
244: group_lf_evt_ocrd_dt date,
245: copy_ws_bdgt_val ben_cwb_person_rates.copy_ws_bdgt_val%type,
246: copy_dist_bdgt_val ben_cwb_person_rates.copy_dist_bdgt_val%type,

Line 694: from ben_pl_f pln

690: --
691: cursor c_get_pl_currency_cd
692: is
693: select pln.nip_pl_uom
694: from ben_pl_f pln
695: where pln.pl_id = p_pl_id
696: and p_effective_date between
697: pln.effective_start_date and pln.effective_end_date;
698: begin

Line 1320: ben_pl_f pln,

1316: group_pln.trk_inelig_per_flag
1317: from ben_popl_enrt_typ_cycl_f pet,
1318: ben_enrt_perd enp,
1319: ben_ler_f ler,
1320: ben_pl_f pln,
1321: ben_pl_f group_pln
1322: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1323: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1324: and pet.business_group_id = enp.business_group_id

Line 1321: ben_pl_f group_pln

1317: from ben_popl_enrt_typ_cycl_f pet,
1318: ben_enrt_perd enp,
1319: ben_ler_f ler,
1320: ben_pl_f pln,
1321: ben_pl_f group_pln
1322: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1323: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1324: and pet.business_group_id = enp.business_group_id
1325: and cv_lf_evt_ocrd_dt

Line 1364: ben_pl_f group_pln

1360: group_pln.trk_inelig_per_flag
1361: from ben_popl_enrt_typ_cycl_f pet,
1362: ben_enrt_perd enp,
1363: ben_ler_f ler,
1364: ben_pl_f group_pln
1365: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1366: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1367: -- and pet.business_group_id = enp.business_group_id
1368: and cv_lf_evt_ocrd_dt

Line 1389: from ben_pl_f

1385: --
1386: cursor get_pl_wthn_group_pl(cv_group_pl_id number,
1387: cv_lf_evt_ocrd_dt date) is
1388: select count(*)
1389: from ben_pl_f
1390: where group_pl_id = cv_group_pl_id
1391: and cv_lf_evt_ocrd_dt between effective_start_date and
1392: effective_end_date;
1393: --

Line 1824: from ben_pl_f pl

1820: and cv_pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id;
1821: --
1822: cursor c_pln(cv_effective_date date) is
1823: select pl.trk_inelig_per_flag
1824: from ben_pl_f pl
1825: where pl.pl_id = p_group_pl_id
1826: and cv_effective_date between pl.effective_start_date and
1827: pl.effective_end_date;
1828: --

Line 2540: from ben_pl_f pln

2536: select '1' pln_order,
2537: pln.pl_id,
2538: pln.business_group_id,
2539: pln.name
2540: from ben_pl_f pln
2541: where pln.group_pl_id = p_pl_id
2542: and l_lf_evt_ocrd_dt between pln.effective_start_date
2543: and pln.effective_end_date
2544: and pln.pl_id =pln.group_pl_id

Line 2551: from ben_pl_f pln

2547: select '2' pln_order,
2548: pln.pl_id,
2549: pln.business_group_id,
2550: pln.name
2551: from ben_pl_f pln
2552: where pln.group_pl_id = p_pl_id
2553: and l_lf_evt_ocrd_dt between pln.effective_start_date
2554: and pln.effective_end_date
2555: and pln.pl_id <> pln.group_pl_id

Line 2693: ben_pl_f pln

2689: cv_eff_dt date) is
2690: select null
2691: from BEN_PRTN_ELIG_F epa,
2692: BEN_PRTN_ELIG_PRFL_f cep,
2693: ben_pl_f pln
2694: where pln.group_pl_id = cv_pl_id
2695: and pln.group_pl_id <> pln.pl_id
2696: and epa.pl_id = pln.pl_id
2697: and epa.prtn_elig_id = cep.prtn_elig_id

Line 3368: ,ben_pl_f pl

3364: cursor c_group_oipl(cv_lf_evt_ocrd_dt in date) is
3365: select group_oipl.oipl_id
3366: from ben_oipl_f oipl
3367: ,ben_oipl_f group_oipl
3368: ,ben_pl_f pl
3369: ,ben_opt_f opt
3370: where oipl.oipl_id = p_oipl_id
3371: and oipl.opt_id = opt.opt_id
3372: and opt.group_opt_id = group_oipl.opt_id