APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_PL_F

Line 1345: ben_pl_f pln

1341: enp.prsvr_bdgt_cd,
1342: DECODE(pln.pl_id,pln.group_pl_id,'Y','N') Group_plan
1343: from ben_enrt_perd enp,
1344: ben_popl_enrt_typ_cycl_f pet,
1345: ben_pl_f pln
1346: where pet.pl_id = p_pl_id
1347: and pet.business_group_id = p_business_group_id
1348: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1349: and enp.asnd_lf_evt_dt = p_lf_evt_ocrd_dt

Line 1492: ben_pl_f pl

1488: cursor c8 is
1489: select 'x' found
1490: from ben_cvg_amt_calc_mthd_f ccm,
1491: ben_pl_typ_f pt,
1492: ben_pl_f pl
1493: where pl.pl_id = p_pl_id
1494: and pt.pl_typ_id = pl.pl_typ_id
1495: and pt.opt_typ_cd = 'CWB'
1496: and (ccm.pl_id = pl.pl_id or

Line 4886: from ben_pl_f pl

4882: l_package varchar2(80) := g_package||'.update_cwb_epe';
4883:
4884: cursor c_pln is
4885: select pl.trk_inelig_per_flag
4886: from ben_pl_f pl
4887: where pl.pl_id = l_pl_id
4888: and p_effective_date between pl.effective_start_date and
4889: pl.effective_end_date;
4890:

Line 7435: from ben_pl_f pl

7431: and action_status_cd = 'P';
7432:
7433: cursor c_pln is
7434: select pl.trk_inelig_per_flag
7435: from ben_pl_f pl
7436: where pl.pl_id = p_pl_id
7437: and l_effective_date between pl.effective_start_date and
7438: pl.effective_end_date;
7439: --

Line 7480: l_trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type;

7476: l_id_flex_num per_business_groups.people_group_structure%TYPE;
7477: --
7478: --
7479: l_ler_override_id number;
7480: l_trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type;
7481: l_request_id number;
7482: l_object_version_number ben_benefit_actions.object_version_number%type;
7483: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
7484: l_chunk_size number;

Line 8361: l_pl_rec ben_pl_f%rowtype;

8357: --
8358: l_package varchar2(80);
8359: l_comp_object_name varchar2(80);
8360: l_pgm_rec ben_pgm_f%rowtype;
8361: l_pl_rec ben_pl_f%rowtype;
8362: l_oipl_rec ben_oipl_f%rowtype;
8363: l_opt_rec ben_opt_f%rowtype;
8364: l_plip_rec ben_plip_f%rowtype;
8365: l_ptip_rec ben_ptip_f%rowtype;

Line 9772: ben_pl_f pln,

9768: p_gsp_plip_id number) is
9769: select ptip.ptip_id,
9770: pln.pl_id
9771: from ben_ptip_f ptip,
9772: ben_pl_f pln,
9773: ben_plip_f plip
9774: where plip.plip_id = p_gsp_plip_id
9775: and plip.pgm_id = p_gsp_pgm_id
9776: and p_effective_date between plip.effective_start_date

Line 9888: l_currpl_row ben_pl_f%rowtype;

9884: l_curretpr_row ben_elig_to_prte_rsn_f%rowtype;
9885: l_currpgm_row ben_pgm_f%rowtype;
9886: l_currptip_row ben_ptip_f%rowtype;
9887: l_currplip_row ben_plip_f%rowtype;
9888: l_currpl_row ben_pl_f%rowtype;
9889: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
9890: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
9891: l_parpgm_row ben_pgm_f%rowtype;
9892: l_parptip_row ben_ptip_f%rowtype;

Line 9894: l_parpl_row ben_pl_f%rowtype;

9890: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
9891: l_parpgm_row ben_pgm_f%rowtype;
9892: l_parptip_row ben_ptip_f%rowtype;
9893: l_parplip_row ben_plip_f%rowtype;
9894: l_parpl_row ben_pl_f%rowtype;
9895: l_paropt_row ben_cobj_cache.g_opt_inst_row;
9896: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
9897: l_per_row per_all_people_F%rowtype;
9898: l_pil_row ben_per_in_ler%rowtype;

Line 10138: (pl_id ben_pl_f.pl_id%type

10134: l_defer_popl_id NUMBER;
10135: l_defer_popl_ovn NUMBER;
10136:
10137: type l_defer_deenrl_rec is record
10138: (pl_id ben_pl_f.pl_id%type
10139: ,pgm_id ben_pgm_f.pgm_id%type
10140: ,chc_exists boolean
10141: ,newly_inelig_exists boolean
10142: );