APPS.BEN_RT_PRFL_CACHE dependencies on BEN_MANAGE_LIFE_EVENTS

Line 207: if ben_manage_life_events.fonm = 'Y' then

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;

Line 209: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then

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

Line 211: l_todate := ben_manage_life_events.g_fonm_rt_strt_dt;

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;

Line 213: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

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

Line 215: l_todate := ben_manage_life_events.g_fonm_cvg_strt_dt;

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;

Line 258: if ben_manage_life_events.fonm = 'Y' then

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

Line 260: if ben_manage_life_events.g_fonm_rt_strt_dt is not null then

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 || ''')';

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 266: elsif ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

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 || ''')';

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