DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_EVALUATE_DPNT_ELG_PROFILES

Line 197: hr_utility.set_location(' elig chnage dt:'||ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,109);

193: ,p_cvg_end_cd => l_cvg_end_cd
194: ,p_cvg_end_rl => l_cvg_end_rl
195: );
196: hr_utility.set_location(' cvg end dt cd :'||l_cvg_end_cd ,10);
197: hr_utility.set_location(' elig chnage dt:'||ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,109);
198: -- tilak 2455430 : I dont think we need the if condition as it is
199: -- only AED and ODBED are avaialble
200: -- for end dt codes This conditon makes the AED calc wrong , get_elig_change_dt return
201: -- Date of birth -1 that is not the AED date but ODBED

Line 206: -- l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;

202:
203: --if (l_cvg_end_cd in ('AED','ODBED','AFDEM','ALDEM','AFDFEM','OMFED',
204: -- 'TMFED','30DFLED','TDBED','60DFLED','SDFED','SDBED',
205: -- 'TODFED')) then
206: -- l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
207: -- hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,110);
208: --else
209: ben_determine_date.main
210: (P_DATE_CD => l_cvg_end_cd

Line 219: ,P_LF_EVT_OCRD_DT => ben_evaluate_dpnt_elg_profiles.

215: ,P_PL_ID => p_pl_id
216: ,P_OIPL_ID => p_oipl_id
217: ,P_BUSINESS_GROUP_ID => p_business_group_id
218: ,P_EFFECTIVE_DATE => l_effective
219: ,P_LF_EVT_OCRD_DT => ben_evaluate_dpnt_elg_profiles.
220: get_elig_change_dt + 1
221: ,P_RETURNED_DATE => l_enrt_cvg_end_dt
222: );
223: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,111);

Line 226: l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;

222: );
223: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,111);
224: --end if;
225: if l_enrt_cvg_end_dt is null then
226: l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
227: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,112);
228: end if;
229: p_returned_end_dt := l_enrt_cvg_end_dt;
230: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1489: ben_evaluate_dpnt_elg_profiles.main

1485: l_level := 'PL';
1486: --
1487: end if;
1488: --
1489: ben_evaluate_dpnt_elg_profiles.main
1490: (p_contact_relationship_id => l_rec.contact_relationship_id,
1491: p_contact_person_id => p_person_id,
1492: p_pgm_id => l_rec.pgm_id,
1493: p_pl_id => l_rec.pl_id,

Line 1518: l_egd_elig_thru_dt := ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;

1514: -- 5100008 : Added this to fetch EGD ELIG_THRU_DT
1515: if (l_rec.date_end <= p_effective_date) then
1516: l_egd_elig_thru_dt := l_rec.date_end;
1517: else
1518: l_egd_elig_thru_dt := ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
1519: end if;
1520: -- 5100008 ENDS
1521:
1522: --

Line 1748: p_lf_evt_ocrd_dt => ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,

1744: p_business_group_id => p_business_group_id,
1745: p_proc_cd1 => 'DPNTENDENRT',
1746: p_proc_cd2 => 'HPADPNTLC',
1747: p_effective_date => p_effective_date,
1748: p_lf_evt_ocrd_dt => ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,
1749: p_source => 'bendsgel');
1750: --
1751: g_designations_ended:=g_designations_ended+1;
1752: l_person_ended:='Y';