Handling Date Parameters in Oracle Applications

Everytime we choose 'FND_STANDARD_DATE' in our Parameters we often get a lot of type casting errors.

It is because the 'FND_STANDARD_DATE' is of the following format.
'YYYY/MM/DD HH24:MI:SS'

Below example shows you how to handle a parameter in your queries