46:
47: --
48: -- Building date range where clause
49: --
50: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
51: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
52: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
53: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
54:
47: --
48: -- Building date range where clause
49: --
50: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
51: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
52: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
53: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
54:
55: IF ( P_DATE_FROM IS NOT NULL ) THEN
48: -- Building date range where clause
49: --
50: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
51: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
52: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
53: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
54:
55: IF ( P_DATE_FROM IS NOT NULL ) THEN
56:
49: --
50: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
51: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
52: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
53: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
54:
55: IF ( P_DATE_FROM IS NOT NULL ) THEN
56:
57: IF ( P_DATE_TO IS NOT NULL ) THEN