[Home] [Help]
469: --
470: if not p_comp_obj_mode or
471: (p_eval_typ <> 'E' and
472: not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
473: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))
474: ) then
475: --
476: ben_derive_factors.determine_los
477: (p_person_id => p_person_id
677: --
678: if not p_comp_obj_mode or
679: (p_eval_typ <> 'E' and
680: not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
681: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))
682: ) then
683: --
684: ben_derive_factors.determine_age
685: (p_person_id => p_person_id
891: --
892: if not p_comp_obj_mode or
893: (p_eval_typ <> 'E' and
894: not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
895: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))
896: ) then
897: --
898: ben_derive_factors.determine_los
899: (p_person_id => p_person_id,
6528: and pen.prtt_enrt_rslt_stat_cd is null
6529: and l_date_to_use
6530: between pdp.cvg_strt_dt
6531: and pdp.cvg_thru_dt
6532: and pdp.effective_end_date = hr_api.g_eot;
6533: --
6534: begin
6535: --
6536: hr_utility.set_location('Entering: '||l_proc, 10);
6775: and pdp.business_group_id = pen.business_group_id
6776: and p_date_to_use
6777: between pdp.cvg_strt_dt
6778: and pdp.cvg_thru_dt
6779: and pdp.effective_end_date = hr_api.g_eot;
6780: --
6781: begin
6782: --
6783: hr_utility.set_location('Entering: '||l_proc, 10);
7090: and pdp.business_group_id = pen.business_group_id
7091: and p_date_to_use
7092: between pdp.cvg_strt_dt
7093: and pdp.cvg_thru_dt
7094: and pdp.effective_end_date = hr_api.g_eot;
7095: --
7096: cursor c2(p_pl_id in number,p_date_to_use date ) is
7097: select null
7098: from ben_pl_regn_f prg
7242: and pen.prtt_enrt_rslt_stat_cd is null
7243: and l_date_to_use -- 5550851
7244: between pdp.cvg_strt_dt
7245: and pdp.cvg_thru_dt
7246: and pdp.effective_end_date = hr_api.g_eot;
7247: --
7248: begin
7249: --
7250: hr_utility.set_location('Entering: '||l_proc, 10);
7677: --
7678: l_ttl_cvg_vol number ;
7679: l_dummy char;
7680: --
7681: l_eot date := hr_api.g_eot;
7682: --
7683: cursor c_bnft_amt(cp_lf_evt_ocrd_dt in date ,
7684: cp_effective_date in date ,
7685: cp_business_group_id in number) is
7814: --
7815: l_ttl_prtt number ;
7816: l_dummy char;
7817: --
7818: l_eot date := hr_api.g_eot;
7819: --
7820: cursor c_ttl_prtt(cp_lf_evt_ocrd_dt in date ,
7821: cp_effective_date in date ,
7822: cp_business_group_id in number) is
7949: l_ele_num pls_integer;
7950: --
7951: l_dummy char ;
7952: --
7953: l_eot date := hr_api.g_eot;
7954: --
7955: cursor c_prtt_in_pl(cp_person_id in number,
7956: cp_pl_id in number,
7957: cp_lf_evt_ocrd_dt in date ,
8059: l_ele_num pls_integer;
8060: --
8061: l_dummy char ;
8062: --
8063: l_eot date := hr_api.g_eot;
8064: --
8065: cursor c_prtt_in_oipl(cp_person_id in number,
8066: cp_pl_typ_opt_typ_id in number,
8067: cp_oipl_id in number,
10011: (p_soft_coding_keyflex_id => l_ass_rec.soft_coding_keyflex_id,
10012: p_rec => l_hsc_rec);
10013: --
10014: if l_hsc_rec.segment1 is not null and
10015: hr_api.return_legislation_code(p_business_group_id) = 'US'
10016: then
10017: --
10018: ben_org_object.get_object
10019: (p_organization_id => l_hsc_rec.segment1,
10023: --
10024: end if;
10025: --
10026: if l_eligprof_dets(l_elptorrw_num).elig_lgl_enty_flag = 'Y'
10027: and hr_api.return_legislation_code(p_business_group_id) = 'US'
10028: then
10029: check_lgl_enty_elig
10030: (p_eligy_prfl_id => l_eligprof_dets(l_elptorrw_num).
10031: eligy_prfl_id,
10163: --
10164: hr_utility.set_location(' here 3 ',999);
10165: if p_person_id is not null and
10166: l_typ_rec(1).system_person_type = 'EMP' and
10167: nvl(p_asg_status,hr_api.g_varchar2) <> 'TERM_ASSIGN' then
10168:
10169: hr_utility.set_location(l_proc||' Not TERM ASSIGN',48);
10170:
10171: if l_eligprof_dets(l_elptorrw_num).elig_pct_fl_tm_flag = 'Y' then