description Reference for the CAST and CONVERT Transact-SQL functions. These functions convert expressions from one data type to another.
AND PRH.CREATION_DATE BETWEEN PPF1.EFFECTIVE_START_DATE AND PPF1.EFFECTIVE_END_DATE AND PPF2.AGENT_ID(+) = MSI.BUYER_ID AND (:P_PRAPPROVE_FROM_DT IS NULL OR TRUNC(PRH.APPROVED_DATE) BETWEEN ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results