APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_PL_F

Line 235: group_pl_id ben_pl_f.pl_id%type,

231: -- table.
232: --
233: type g_cache_copy_person_bdgt_rt is record
234: (person_id ben_cwb_person_rates.person_id%type,
235: group_pl_id ben_pl_f.pl_id%type,
236: group_oipl_id ben_cwb_person_rates.group_oipl_id%type,
237: group_lf_evt_ocrd_dt date,
238: copy_ws_bdgt_val ben_cwb_person_rates.copy_ws_bdgt_val%type,
239: copy_dist_bdgt_val ben_cwb_person_rates.copy_dist_bdgt_val%type,

Line 665: from ben_pl_f pln

661: --
662: cursor c_get_pl_currency_cd
663: is
664: select pln.nip_pl_uom
665: from ben_pl_f pln
666: where pln.pl_id = p_pl_id
667: and p_effective_date between
668: pln.effective_start_date and pln.effective_end_date;
669: begin

Line 1290: ben_pl_f pln,

1286: group_pln.trk_inelig_per_flag
1287: from ben_popl_enrt_typ_cycl_f pet,
1288: ben_enrt_perd enp,
1289: ben_ler_f ler,
1290: ben_pl_f pln,
1291: ben_pl_f group_pln
1292: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1293: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1294: and pet.business_group_id = enp.business_group_id

Line 1291: ben_pl_f group_pln

1287: from ben_popl_enrt_typ_cycl_f pet,
1288: ben_enrt_perd enp,
1289: ben_ler_f ler,
1290: ben_pl_f pln,
1291: ben_pl_f group_pln
1292: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1293: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1294: and pet.business_group_id = enp.business_group_id
1295: and cv_lf_evt_ocrd_dt

Line 1334: ben_pl_f group_pln

1330: group_pln.trk_inelig_per_flag
1331: from ben_popl_enrt_typ_cycl_f pet,
1332: ben_enrt_perd enp,
1333: ben_ler_f ler,
1334: ben_pl_f group_pln
1335: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1336: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1337: -- and pet.business_group_id = enp.business_group_id
1338: and cv_lf_evt_ocrd_dt

Line 1359: from ben_pl_f

1355: --
1356: cursor get_pl_wthn_group_pl(cv_group_pl_id number,
1357: cv_lf_evt_ocrd_dt date) is
1358: select count(*)
1359: from ben_pl_f
1360: where group_pl_id = cv_group_pl_id
1361: and cv_lf_evt_ocrd_dt between effective_start_date and
1362: effective_end_date;
1363: --

Line 1779: from ben_pl_f pl

1775: and cv_pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id;
1776: --
1777: cursor c_pln(cv_effective_date date) is
1778: select pl.trk_inelig_per_flag
1779: from ben_pl_f pl
1780: where pl.pl_id = p_group_pl_id
1781: and cv_effective_date between pl.effective_start_date and
1782: pl.effective_end_date;
1783: --

Line 2495: from ben_pl_f pln

2491: select '1' pln_order,
2492: pln.pl_id,
2493: pln.business_group_id,
2494: pln.name
2495: from ben_pl_f pln
2496: where pln.group_pl_id = p_pl_id
2497: and l_lf_evt_ocrd_dt between pln.effective_start_date
2498: and pln.effective_end_date
2499: and pln.pl_id =pln.group_pl_id

Line 2506: from ben_pl_f pln

2502: select '2' pln_order,
2503: pln.pl_id,
2504: pln.business_group_id,
2505: pln.name
2506: from ben_pl_f pln
2507: where pln.group_pl_id = p_pl_id
2508: and l_lf_evt_ocrd_dt between pln.effective_start_date
2509: and pln.effective_end_date
2510: and pln.pl_id <> pln.group_pl_id

Line 2648: ben_pl_f pln

2644: cv_eff_dt date) is
2645: select null
2646: from BEN_PRTN_ELIG_F epa,
2647: BEN_PRTN_ELIG_PRFL_f cep,
2648: ben_pl_f pln
2649: where pln.group_pl_id = cv_pl_id
2650: and pln.group_pl_id <> pln.pl_id
2651: and epa.pl_id = pln.pl_id
2652: and epa.prtn_elig_id = cep.prtn_elig_id

Line 3316: ,ben_pl_f pl

3312: cursor c_group_oipl(cv_lf_evt_ocrd_dt in date) is
3313: select group_oipl.oipl_id
3314: from ben_oipl_f oipl
3315: ,ben_oipl_f group_oipl
3316: ,ben_pl_f pl
3317: ,ben_opt_f opt
3318: where oipl.oipl_id = p_oipl_id
3319: and oipl.opt_id = opt.opt_id
3320: and opt.group_opt_id = group_oipl.opt_id