188: ,p_cvg_end_cd => l_cvg_end_cd
189: ,p_cvg_end_rl => l_cvg_end_rl
190: );
191: hr_utility.set_location(' cvg end dt cd :'||l_cvg_end_cd ,10);
192: hr_utility.set_location(' elig chnage dt:'||ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,109);
193: -- tilak 2455430 : I dont think we need the if condition as it is
194: -- only AED and ODBED are avaialble
195: -- for end dt codes This conditon makes the AED calc wrong , get_elig_change_dt return
196: -- Date of birth -1 that is not the AED date but ODBED
197:
198: --if (l_cvg_end_cd in ('AED','ODBED','AFDEM','ALDEM','AFDFEM','OMFED',
199: -- 'TMFED','30DFLED','TDBED','60DFLED','SDFED','SDBED',
200: -- 'TODFED')) then
201: -- l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
202: -- hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,110);
203: --else
204: ben_determine_date.main
205: (P_DATE_CD => l_cvg_end_cd
210: ,P_PL_ID => p_pl_id
211: ,P_OIPL_ID => p_oipl_id
212: ,P_BUSINESS_GROUP_ID => p_business_group_id
213: ,P_EFFECTIVE_DATE => l_effective
214: ,P_LF_EVT_OCRD_DT => ben_evaluate_dpnt_elg_profiles.
215: get_elig_change_dt + 1
216: ,P_RETURNED_DATE => l_enrt_cvg_end_dt
217: );
218: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,111);
217: );
218: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,111);
219: --end if;
220: if l_enrt_cvg_end_dt is null then
221: l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
222: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,112);
223: end if;
224: p_returned_end_dt := l_enrt_cvg_end_dt;
225: hr_utility.set_location(' Leaving:'||l_proc, 70);
1475: l_level := 'PL';
1476: --
1477: end if;
1478: --
1479: ben_evaluate_dpnt_elg_profiles.main
1480: (p_contact_relationship_id => l_rec.contact_relationship_id,
1481: p_contact_person_id => p_person_id,
1482: p_pgm_id => l_rec.pgm_id,
1483: p_pl_id => l_rec.pl_id,
1504: -- 5100008 : Added this to fetch EGD ELIG_THRU_DT
1505: if (l_rec.date_end <= p_effective_date) then
1506: l_egd_elig_thru_dt := l_rec.date_end;
1507: else
1508: l_egd_elig_thru_dt := ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
1509: end if;
1510: -- 5100008 ENDS
1511:
1512: --
1723: p_business_group_id => p_business_group_id,
1724: p_proc_cd1 => 'DPNTENDENRT',
1725: p_proc_cd2 => 'HPADPNTLC',
1726: p_effective_date => p_effective_date,
1727: p_lf_evt_ocrd_dt => ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,
1728: p_source => 'bendsgel');
1729: --
1730: g_designations_ended:=g_designations_ended+1;
1731: l_person_ended:='Y';