APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on FND_DATE

Line 356: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));

352: /*
353: l_effective_date:=to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
354: l_effective_date:=to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
355: */
356: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
357: --
358: -- Put row in fnd_sessions
359: --
360: dt_fndate.change_ses_date

Line 787: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));

783: /*
784: l_effective_date:=to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
785: l_effective_date:=to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
786: */
787: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
788: --
789: -- Put row in fnd_sessions
790: --
791: dt_fndate.change_ses_date