APPS.OTA_FRM_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

   select name
   from ota_forums_tl
   where forum_id = P_FORUM_ID
   and language = userenv('LANG');

Line: 21

     select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
     into C_FROM_DATE
     from dual;

Line: 29

     select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
     into C_TO_DATE
     from dual;