53:
54: --
55: -- Building date range where clause
56: --
57: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
58: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
59: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
60: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
61:
54: --
55: -- Building date range where clause
56: --
57: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
58: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
59: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
60: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
61:
62: IF ( P_DATE_FROM IS NOT NULL ) THEN
55: -- Building date range where clause
56: --
57: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
58: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
59: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
60: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
61:
62: IF ( P_DATE_FROM IS NOT NULL ) THEN
63:
56: --
57: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
58: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
59: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_FROM);
60: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(D_DATE_TO);
61:
62: IF ( P_DATE_FROM IS NOT NULL ) THEN
63:
64: IF ( P_DATE_TO IS NOT NULL ) THEN