Changed on Date logic in ODI(Biapps 11.1.1.8.1)

Changed on Date logic in ODI (Biapps11.1.1.8.1) if source system is JDE
----------------------------------------------------------------------
RUN_REPLICATED_TRANSACTIONAL('#IS_SDS_DEPLOYED',
JDE_DATE_CONV(TO_INTEGER(SQ_F4140.PJUPMJ),
TO_INTEGER(SQ_F4140.PJTDAY)),
SQ_F4140.CDC$_SRC_LAST_UPDATE_DATE)

The above function will work based on the IS_SDS_DEPLOYED variable.
If IS_SDS_DEPLOYED=N then JDE_DATE_CONV(TO_INTEGER(SQ_F4140.PJUPMJ),TO_INTEGER(SQ_F4140.PJTDAY))--JDE_DATE_CONV function will convert the JDE formate to the reguler formate like MM/DD/YYYY
ELSE
F4140.CDC$_SRC_LAST_UPDATE_DATE--(Golden gate date)

Implementation OF JDE_DATE_CONV FUNCTION
---------------------------------------------------------

CASE
WHEN $(DATE_PART)=0 OR $(DATE_PART) IS NULL THEN NULL
ELSE
DATEADD(day,($(DATE_PART)-(1000*(ROUND(($(DATE_PART)/1000),0)))),DATEADD(year, ROUND(($(DATE_PART)/1000),0), '1899-12-31 00:00:00'))
END