APPS.OKL_LEASE_APP_WF SQL Statements

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

Line: 35

    SELECT USER_NAME
      FROM FND_USER
     WHERE USER_ID = fnd_global.user_id;

Line: 41

    SELECT APPLICATION_ID
      FROM FND_APPLICATION
     WHERE APPLICATION_SHORT_NAME = G_APP_NAME;

Line: 46

      SELECT MEANING
        FROM FND_LOOKUPS
       WHERE LOOKUP_TYPE = 'OKL_FRONTEND_OBJECTS'
         AND LOOKUP_CODE = object_type;

Line: 173

    SELECT LAP.REFERENCE_NUMBER   LEASE_APP_NAME
         , LAP.APPLICATION_STATUS LEASE_APP_STATUS
         , LAP.VALID_FROM         EFFECTIVE_FROM
         , LAP.VALID_TO           EFFECTIVE_TO
      FROM OKL_LEASE_APPLICATIONS_V LAP
     WHERE LAP.ID = cp_la_id;

Line: 451

      SELECT LATV.NAME           LAT_NAME
           , LAVV.VERSION_NUMBER
           , LAVV.VALID_FROM     EFFECTIVE_FROM
           , LAVV.VALID_TO       EFFECTIVE_TO
           , LAVV.VERSION_STATUS
        FROM OKL_LEASEAPP_TEMPLATES     LATV
           , OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
       WHERE LAVV.LEASEAPP_TEMPLATE_ID = LATV.ID
         AND LAVV.ID = cp_lat_ver_id;

Line: 630

    SELECT LAB.APPLICATION_STATUS
      FROM OKL_LEASE_APPLICATIONS_B LAB
     WHERE LAB.ID = cp_la_id;

Line: 830

      SELECT LAVV.OBJECT_VERSION_NUMBER
        FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
       WHERE LAVV.ID = cp_version_id;

Line: 866

        OKL_LAV_PVT.update_row(p_api_version              => l_api_version
                             , p_init_msg_list              => l_init_msg_list
                             , x_return_status              => l_return_status
                             , x_msg_count                  => l_msg_count
                             , x_msg_data                   => l_msg_data
                             , p_lavv_rec                   => l_lavv_rec
                             , x_lavv_rec                   => lx_lavv_rec);