[Home] [Help]
323: date-1 or effective date -1.
324: Changed remove_cert_action_items.
325: 115.142 20-jul-00 kmahendr Effective date is to be passed if effective date -1 >
326: life event occurred - related to version -115.141
327: 115.143 11-aug-00 gperry Fixed call to ben_determine_date.
328: Was passing cvg_end_dt_cd and
329: cvg_strt_dt_rl. Should have passed
330: cvg_end_dt_rl.
331: Fix for WWBUG 1375481.
427: benuneai, pass this to p_called_from parameter of
428: unhook_dpnt.
429: 2. When elig_per_elctbl_chc_id is null, we need to pass
430: lee_rsn_id and enrt_perd_id also along with pgm,pl,oipl
431: to ben_determine_date.rate_and_coverage_dates call.
432: 115.184 25-Jun-02 tjesumic bug:2479616 for the 1 prior rate end date code, the date is
433: calcualted on coverage start date, that was changed to
434: calculate on rate start date
435: 115.185 05-Jul-02 ikasire bug:2479616 fixed a typo in the 1 prior rate if condition
1920: open c_pel(p_elig_per_elctbl_chc_id);
1921: fetch c_pel into l_pel;
1922: close c_pel;
1923:
1924: ben_determine_date.rate_and_coverage_dates
1925: (p_which_dates_cd => 'R'
1926: ,p_date_mandatory_flag => 'Y'
1927: ,p_compute_dates_flag => 'Y'
1928: ,p_business_group_id => p_business_group_id
3663: open c_pel(l_prem.elig_per_elctbl_chc_id);
3664: fetch c_pel into l_pel;
3665: close c_pel;
3666:
3667: ben_determine_date.rate_and_coverage_dates
3668: (p_which_dates_cd => 'R'
3669: ,p_date_mandatory_flag => 'Y'
3670: ,p_compute_dates_flag => 'Y'
3671: ,p_business_group_id => p_business_group_id
5095: hr_utility.set_location('dpnt_strt_cd'|| l_cvg_strt_cd,15);
5096: end if;
5097: if (p_calc_strt_dt and l_cvg_strt_cd is not NULL) then
5098: l_step := 20;
5099: ben_determine_date.main
5100: (P_DATE_CD => l_cvg_strt_cd
5101: ,p_formula_id => l_cvg_strt_rl
5102: ,P_ELIG_PER_ELCTBL_CHC_ID => p_elig_per_elctbl_chc_id
5103: ,P_BUSINESS_GROUP_ID => p_business_group_id
5108: l_cvg_strt_dt := NULL;
5109: end if;
5110: if (p_calc_end_dt and l_cvg_end_cd is not NULL) then
5111: l_step := 30;
5112: ben_determine_date.main
5113: (P_DATE_CD => l_cvg_end_cd
5114: ,p_formula_id => l_cvg_end_rl
5115: ,p_enrt_cvg_end_dt => p_enrt_cvg_end_dt
5116: ,P_ELIG_PER_ELCTBL_CHC_ID => p_elig_per_elctbl_chc_id
5136: ,p_cvg_end_rl => l_cvg_end_rl
5137: );
5138: if (p_calc_strt_dt and l_cvg_strt_cd is not null) then
5139: l_step := 50;
5140: ben_determine_date.main
5141: (P_DATE_CD => l_cvg_strt_cd
5142: ,p_formula_id => l_cvg_strt_rl
5143: ,P_PER_IN_LER_ID => p_per_in_ler_id
5144: ,P_PERSON_ID => p_person_id
5153: l_cvg_strt_dt := NULL;
5154: end if;
5155: if (p_calc_end_dt and l_cvg_end_cd is not NULL) then
5156: l_step := 60;
5157: ben_determine_date.main
5158: (P_DATE_CD => l_cvg_end_cd
5159: ,p_formula_id => l_cvg_end_rl
5160: ,p_enrt_cvg_end_dt => p_enrt_cvg_end_dt
5161: ,P_PER_IN_LER_ID => p_per_in_ler_id
7061: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
7062: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
7063: -- eof FONM
7064:
7065: ben_determine_date.rate_and_coverage_dates
7066: (p_which_dates_cd => 'C'
7067: ,p_date_mandatory_flag => 'N'
7068: ,p_compute_dates_flag => 'N'
7069: ,p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
7100: return;
7101: end if;
7102:
7103: --
7104: ben_determine_date.rate_and_coverage_dates
7105: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
7106: ,p_business_group_id => l_pen.business_group_id
7107: ,P_PER_IN_LER_ID => l_pen.per_in_ler_id
7108: ,P_PERSON_ID => l_pen.person_id
7130: ----Bug 6925893
7131: if substr(nvl(l_rt_end_dt_cd, 'X'), 1, 1) = 'W'
7132: and l_ler_typ_cd not in ('IREC','GSP','COMP','ABS','SCHEDDU') then
7133: --determine new rt start date
7134: ben_determine_date.rate_and_coverage_dates
7135: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
7136: ,p_business_group_id => l_pen.business_group_id
7137: ,P_PER_IN_LER_ID => l_pen.per_in_ler_id
7138: ,P_PERSON_ID => l_pen.person_id