Display Date Parameters on EBS env
On EBS R12, I have a couple of date parameters defined for a XML report, using data definition template:
P_START_DATE and P_END_DATE, the value set: FND_Standart_Date.
In the data definition XML
<parameters>
<parameter name="P_START_DATE" datatype="Date"></parameter>
<parameter name="P_END_DATE" datatype="Date"></parameter>
</parameters>
<sqlstatement name="Q_EMP_DATA">
<![CDATA[
select distinct
...
and pss.actual_termination_date between fnd_date.canonical_to_date(:P_START_DATE) and fnd_date.canonical_to_date( :P_END_DATE)
...
]]>
The report pulls rows correctly. But I am trying to display the two date parameters: