APPS.INV_PURGE_PUB SQL Statements

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

Line: 71

      SELECT 1
        INTO l_tempvar
        FROM org_acct_periods
       WHERE organization_id = p_orgid
         AND period_start_date <= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)
         AND schedule_close_date >= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)
         AND open_flag = 'N';

Line: 90

      INSERT INTO mtl_purge_header
                  (
                   purge_id
                 , last_update_date
                 , last_updated_by
                 , last_update_login
                 , creation_date
                 , created_by
                 , purge_date
                 , purge_name
                 , organization_id
                  )
           VALUES (
                   mtl_material_transactions_s.NEXTVAL
                 , SYSDATE
                 , l_user_id
                 , l_login_id
                 , SYSDATE
                 , l_user_id
                 , fnd_date.canonical_to_date(p_purge_date)
                 , p_purge_name
                 , p_orgid
                  );