APPS.BEN_RT_PRFL_CACHE dependencies on FND_DATE

Line 263: ' to_date(''' || fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt) ||

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: --

Line 264: ''', ''' || fnd_date.canonical_dt_mask || ''')';

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: --
268: l_todate_str :=

Line 269: ' to_date(''' || fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt) ||

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: --

Line 270: ''', ''' || fnd_date.canonical_dt_mask || ''')';

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: --
274: l_todate_str :=

Line 275: ' to_date(''' || fnd_date.date_to_canonical(p_lf_evt_ocrd_dt) ||

271: --
272: elsif p_lf_evt_ocrd_dt is not null then
273: --
274: l_todate_str :=
275: ' to_date(''' || fnd_date.date_to_canonical(p_lf_evt_ocrd_dt) ||
276: ''', ''' || fnd_date.canonical_dt_mask || ''')';
277: --
278: else
279: --

Line 276: ''', ''' || fnd_date.canonical_dt_mask || ''')';

272: elsif p_lf_evt_ocrd_dt is not null then
273: --
274: l_todate_str :=
275: ' to_date(''' || fnd_date.date_to_canonical(p_lf_evt_ocrd_dt) ||
276: ''', ''' || fnd_date.canonical_dt_mask || ''')';
277: --
278: else
279: --
280: l_todate_str :=

Line 281: ' to_date(''' || fnd_date.date_to_canonical(p_effective_date) ||

277: --
278: else
279: --
280: l_todate_str :=
281: ' to_date(''' || fnd_date.date_to_canonical(p_effective_date) ||
282: ''', ''' || fnd_date.canonical_dt_mask || ''')';
283:
284: end if;
285: --

Line 282: ''', ''' || fnd_date.canonical_dt_mask || ''')';

278: else
279: --
280: l_todate_str :=
281: ' to_date(''' || fnd_date.date_to_canonical(p_effective_date) ||
282: ''', ''' || fnd_date.canonical_dt_mask || ''')';
283:
284: end if;
285: --
286: else

Line 290: ' to_date(''' || fnd_date.date_to_canonical(p_lf_evt_ocrd_dt) ||

286: else
287: if p_lf_evt_ocrd_dt is not null then
288: --
289: l_todate_str :=
290: ' to_date(''' || fnd_date.date_to_canonical(p_lf_evt_ocrd_dt) ||
291: ''', ''' || fnd_date.canonical_dt_mask || ''')';
292: --
293: else
294: --

Line 291: ''', ''' || fnd_date.canonical_dt_mask || ''')';

287: if p_lf_evt_ocrd_dt is not null then
288: --
289: l_todate_str :=
290: ' to_date(''' || fnd_date.date_to_canonical(p_lf_evt_ocrd_dt) ||
291: ''', ''' || fnd_date.canonical_dt_mask || ''')';
292: --
293: else
294: --
295: l_todate_str :=

Line 296: ' to_date(''' || fnd_date.date_to_canonical(p_effective_date) ||

292: --
293: else
294: --
295: l_todate_str :=
296: ' to_date(''' || fnd_date.date_to_canonical(p_effective_date) ||
297: ''', ''' || fnd_date.canonical_dt_mask || ''')';
298: --
299: end if;
300: end if;

Line 297: ''', ''' || fnd_date.canonical_dt_mask || ''')';

293: else
294: --
295: l_todate_str :=
296: ' to_date(''' || fnd_date.date_to_canonical(p_effective_date) ||
297: ''', ''' || fnd_date.canonical_dt_mask || ''')';
298: --
299: end if;
300: end if;
301: --