203: l_todate date;
204: begin
205: --
206: -- FONM
207: if ben_manage_life_events.fonm = 'Y' then
208: --
209: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then
210: --
211: l_todate := ben_manage_life_events.g_fonm_rt_strt_dt;
205: --
206: -- FONM
207: if ben_manage_life_events.fonm = 'Y' then
208: --
209: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then
210: --
211: l_todate := ben_manage_life_events.g_fonm_rt_strt_dt;
212: --
213: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
207: if ben_manage_life_events.fonm = 'Y' then
208: --
209: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then
210: --
211: l_todate := ben_manage_life_events.g_fonm_rt_strt_dt;
212: --
213: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
214: --
215: l_todate := ben_manage_life_events.g_fonm_cvg_strt_dt;
209: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then
210: --
211: l_todate := ben_manage_life_events.g_fonm_rt_strt_dt;
212: --
213: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
214: --
215: l_todate := ben_manage_life_events.g_fonm_cvg_strt_dt;
216: --
217: elsif p_lf_evt_ocrd_dt is not null then
211: l_todate := ben_manage_life_events.g_fonm_rt_strt_dt;
212: --
213: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
214: --
215: l_todate := ben_manage_life_events.g_fonm_cvg_strt_dt;
216: --
217: elsif p_lf_evt_ocrd_dt is not null then
218: --
219: l_todate := p_lf_evt_ocrd_dt;
254: l_todate_str varchar2(1000);
255: begin
256: --
257: -- FONM
258: if ben_manage_life_events.fonm = 'Y' then
259: --
260: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then
261: --
262: l_todate_str :=
256: --
257: -- FONM
258: if ben_manage_life_events.fonm = 'Y' then
259: --
260: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then
261: --
262: l_todate_str :=
263: ' to_date(''' || fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt) ||
264: ''', ''' || fnd_date.canonical_dt_mask || ''')';
259: --
260: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then
261: --
262: l_todate_str :=
263: ' to_date(''' || fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt) ||
264: ''', ''' || fnd_date.canonical_dt_mask || ''')';
265: --
266: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
267: --
262: l_todate_str :=
263: ' to_date(''' || fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt) ||
264: ''', ''' || fnd_date.canonical_dt_mask || ''')';
265: --
266: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
267: --
268: l_todate_str :=
269: ' to_date(''' || fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt) ||
270: ''', ''' || fnd_date.canonical_dt_mask || ''')';
265: --
266: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
267: --
268: l_todate_str :=
269: ' to_date(''' || fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt) ||
270: ''', ''' || fnd_date.canonical_dt_mask || ''')';
271: --
272: elsif p_lf_evt_ocrd_dt is not null then
273: --