APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on FND_DATE

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

347: /*
348: l_effective_date:=to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
349: l_effective_date:=to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
350: */
351: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
352: --
353: -- Put row in fnd_sessions
354: --
355: dt_fndate.change_ses_date

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

778: /*
779: l_effective_date:=to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
780: l_effective_date:=to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
781: */
782: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
783: --
784: -- Put row in fnd_sessions
785: --
786: dt_fndate.change_ses_date