APPS.CN_PURGE_TABLES_PUB SQL Statements

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

Line: 133

     SELECT period_id
       FROM cn_periods
      WHERE period_name = p_start_period_name
    AND org_id          = p_org_id AND closing_status in ('C', 'P') ;

Line: 140

     SELECT period_id
       FROM cn_periods
      WHERE period_name = p_end_period_name
    AND org_id          = p_org_id AND closing_status in ('C', 'P') ;

Line: 168

   SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;

Line: 386

  SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;