2235: FROM OKL_PROCESS_TMPLTS_B PT,
2236: OKL_PROCESS_TMPLTS_TL PTTL,
2237: FND_LOOKUPS FND,
2238: XDO_TEMPLATES_B XDOB,
2239: XDO_TEMPLATES_TL XDOTL
2240: WHERE PT.PTM_CODE = FND.LOOKUP_CODE
2241: AND XDOB.TEMPLATE_CODE = XDOTL.TEMPLATE_CODE
2242: AND XDOB.APPLICATION_SHORT_NAME = 'OKL'
2243: AND PT.START_DATE <= SYSDATE