[Home] [Help]
1733: enp.prsvr_bdgt_cd,
1734: DECODE(pln.pl_id,pln.group_pl_id,'Y','N') Group_plan
1735: from ben_enrt_perd enp,
1736: ben_popl_enrt_typ_cycl_f pet,
1737: ben_pl_f pln
1738: where pet.pl_id = p_pl_id
1739: and pet.business_group_id = p_business_group_id
1740: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1741: and enp.asnd_lf_evt_dt = p_lf_evt_ocrd_dt
1880: cursor c8 is
1881: select 'x' found
1882: from ben_cvg_amt_calc_mthd_f ccm,
1883: ben_pl_typ_f pt,
1884: ben_pl_f pl
1885: where pl.pl_id = p_pl_id
1886: and pt.pl_typ_id = pl.pl_typ_id
1887: and pt.opt_typ_cd = 'CWB'
1888: and (ccm.pl_id = pl.pl_id or
5274: l_package varchar2(80) := g_package||'.update_cwb_epe';
5275:
5276: cursor c_pln is
5277: select pl.trk_inelig_per_flag
5278: from ben_pl_f pl
5279: where pl.pl_id = l_pl_id
5280: and p_effective_date between pl.effective_start_date and
5281: pl.effective_end_date;
5282:
7837: and action_status_cd = 'P';
7838:
7839: cursor c_pln is
7840: select pl.trk_inelig_per_flag
7841: from ben_pl_f pl
7842: where pl.pl_id = p_pl_id
7843: and l_effective_date between pl.effective_start_date and
7844: pl.effective_end_date;
7845: --
7882: l_id_flex_num per_business_groups.people_group_structure%TYPE;
7883: --
7884: --
7885: l_ler_override_id number;
7886: l_trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type;
7887: l_request_id number;
7888: l_object_version_number ben_benefit_actions.object_version_number%type;
7889: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
7890: l_chunk_size number;
8765: --
8766: l_package varchar2(80);
8767: l_comp_object_name varchar2(80);
8768: l_pgm_rec ben_pgm_f%rowtype;
8769: l_pl_rec ben_pl_f%rowtype;
8770: l_oipl_rec ben_oipl_f%rowtype;
8771: l_opt_rec ben_opt_f%rowtype;
8772: l_plip_rec ben_plip_f%rowtype;
8773: l_ptip_rec ben_ptip_f%rowtype;
10176: p_gsp_plip_id number) is
10177: select ptip.ptip_id,
10178: pln.pl_id
10179: from ben_ptip_f ptip,
10180: ben_pl_f pln,
10181: ben_plip_f plip
10182: where plip.plip_id = p_gsp_plip_id
10183: and plip.pgm_id = p_gsp_pgm_id
10184: and p_effective_date between plip.effective_start_date
10340: l_curretpr_row ben_elig_to_prte_rsn_f%rowtype;
10341: l_currpgm_row ben_pgm_f%rowtype;
10342: l_currptip_row ben_ptip_f%rowtype;
10343: l_currplip_row ben_plip_f%rowtype;
10344: l_currpl_row ben_pl_f%rowtype;
10345: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10346: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
10347: l_parpgm_row ben_pgm_f%rowtype;
10348: l_parptip_row ben_ptip_f%rowtype;
10346: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
10347: l_parpgm_row ben_pgm_f%rowtype;
10348: l_parptip_row ben_ptip_f%rowtype;
10349: l_parplip_row ben_plip_f%rowtype;
10350: l_parpl_row ben_pl_f%rowtype;
10351: l_paropt_row ben_cobj_cache.g_opt_inst_row;
10352: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
10353: l_per_row per_all_people_F%rowtype;
10354: l_pil_row ben_per_in_ler%rowtype;
10609: l_defer_popl_id NUMBER;
10610: l_defer_popl_ovn NUMBER;
10611:
10612: type l_defer_deenrl_rec is record
10613: (pl_id ben_pl_f.pl_id%type
10614: ,pgm_id ben_pgm_f.pgm_id%type
10615: ,chc_exists boolean
10616: ,newly_inelig_exists boolean
10617: );