67:
68: --
69: -- Building date range where clause
70: --
71: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
72: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
73: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
74: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
75:
68: --
69: -- Building date range where clause
70: --
71: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
72: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
73: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
74: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
75:
76: IF ( P_DATE_FROM IS NOT NULL ) THEN
69: -- Building date range where clause
70: --
71: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
72: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
73: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
74: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
75:
76: IF ( P_DATE_FROM IS NOT NULL ) THEN
77:
70: --
71: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
72: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
73: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
74: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
75:
76: IF ( P_DATE_FROM IS NOT NULL ) THEN
77:
78: IF ( P_DATE_TO IS NOT NULL ) THEN