APPS.OKL_LRF_INTERFACE_PVT SQL Statements

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

Line: 28

    SELECT 'x'
    FROM   OKL_LS_RT_FCTR_SETS_B
    WHERE  ID = p_lrt_id;

Line: 45

    SELECT 'x'
    FROM   OKL_LS_RT_FCTR_ENTS
    WHERE  LRT_ID                 = p_lrfv_rec.lrt_id
      AND  TERM_IN_MONTHS         = p_lrfv_rec.term_in_months
      AND  RESIDUAL_VALUE_PERCENT = p_lrfv_rec.residual_value_percent;

Line: 91

   PROCEDURE Update_Interface_Status (p_batch_number    IN  NUMBER
                                     ,p_status          IN  VARCHAR2
                                     ,p_lrt_id          IN  NUMBER
                                     ,p_term            IN  NUMBER
                                     ,p_interest_rate   IN  NUMBER
                                     ,p_lrf             IN  NUMBER
                                     ,p_rv_percent      IN  NUMBER
                                     ,x_return_status   OUT NOCOPY VARCHAR2 ) IS

     x_proc_name    VARCHAR2(35) := 'UPDATE_INTERFACE_STATUS';

Line: 101

     update_failed  EXCEPTION;

Line: 107

   END Update_Interface_Status;

Line: 139

  SELECT
         lease_rate_factor
        ,residual_value_percent
        ,term_in_months
        ,interest_rate
  FROM   okl_lrf_interface
  WHERE  batch_number = p_batch_number
  AND    status       = 'VALIDATED';

Line: 182

    SELECT term_in_months, lease_rate_factor, residual_value_percent, interest_rate
    FROM   okl_lrf_interface
    WHERE  batch_number = b_batch_number
    AND    status in ('NEW','FAILED','ERROR','AUTOGEN');

Line: 349

  SELECT DECODE(ARREARS_YN,'N',1,0), DECODE(FRQ_CODE,'M',12,'Q',3,'S',2,'A',1,0)
  FROM   OKL_LS_RT_FCTR_SETS_B
  WHERE  ID = B_LRT_ID;