APPS.OTA_FRM_XMLP_PKG SQL Statements

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

Line: 6

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

Line: 19

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

Line: 27

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