APPS.OKL_LEASE_QUOTE_WORKFLOW_PVT SQL Statements

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

Line: 39

    SELECT parent_object_code, parent_object_id FROM okl_lease_quotes_b
    WHERE id=quote_id;

Line: 136

    SELECT reference_number, valid_from, valid_to  FROM
    OKL_LEASE_APPLICATIONS_B
    WHERE id= lease_app_id;

Line: 227

    SELECT object_version_number
    FROM okl_lease_quotes_b
    WHERE id = p_quote_id;

Line: 240

    okl_lsq_pvt.update_row(p_api_version   => G_API_VERSION
                          ,p_init_msg_list => G_FALSE
                          ,x_return_status => lx_return_status
                          ,x_msg_count     => lx_msg_count
                          ,x_msg_data      => lx_msg_data
                          ,p_lsqv_rec      => l_lease_qte_rec
                          ,x_lsqv_rec      => x_lease_qte_rec );

Line: 293

    SELECT okl_wf_item_s.nextval
    FROM  dual;

Line: 313

    l_parameter_list.DELETE;

Line: 359

    SELECT reference_number
    FROM okl_lease_quotes_v
    WHERE id = p_quote_id;

Line: 441

    SELECT okl_wf_item_s.nextval
    FROM  dual;

Line: 489

          OKL_LAP_PVT.UPDATE_ROW(
            p_api_version           => 1.0
           ,p_init_msg_list         => 'T'
           ,x_return_status         => l_return_status
           ,x_msg_count             => x_msg_count
           ,x_msg_data              => x_msg_data
           ,p_lapv_rec              => l_lapv_rec
           ,x_lapv_rec              => x_lapv_rec);

Line: 521

      l_parameter_list.DELETE;

Line: 561

    SELECT reference_number
    FROM okl_lease_quotes_v
    WHERE id = p_quote_id;

Line: 664

     SELECT application_id
     FROM   fnd_application
     WHERE  application_short_name = 'OKL';

Line: 767

    SELECT reference_number, valid_from, valid_to, parent_object_code, parent_object_id
    FROM okl_lease_quotes_b
    WHERE id = p_quote_id;

Line: 773

      SELECT USER_NAME
        FROM FND_USER
       WHERE USER_ID = fnd_global.user_id; */

Line: 779

      SELECT USER_NAME
        FROM FND_USER
       WHERE USER_ID = p_user_id;

Line: 789

      SELECT APPLICATION_ID
        FROM FND_APPLICATION
       WHERE APPLICATION_SHORT_NAME = G_APP_NAME;

Line: 795

    SELECT reference_number  FROM
    OKL_LEASE_APPLICATIONS_B
    WHERE id= lease_app_id;

Line: 800

    SELECT meaning from fnd_lookups where
    lookup_type='OKL_FRONTEND_OBJECTS' and lookup_code=l_code;

Line: 1028

      SELECT LAP.REFERENCE_NUMBER
           , LAP.APPLICATION_STATUS
      FROM OKL_LEASE_APPLICATIONS_B LAP
      WHERE LAP.ID = cp_lap_id;