APPS.GL_AUTO_ALLOC_PARALLEL_PKG SQL Statements

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

Line: 36

 l_last_updated_by	       Number;

Line: 38

 l_last_update_login           Number;

Line: 54

    Select
      ALLOCATION_SET_NAME
     ,ALLOCATION_SET_ID
     ,ALLOCATION_SET_TYPE_CODE
     ,ACCESS_SET_ID
     ,LEDGER_ID
     ,LEDGER_CURRENCY
     ,DESCRIPTION
     ,PERIOD_NAME
     ,BUDGET_VERSION_ID
     ,BALANCING_SEGMENT_VALUE
     ,JOURNAL_EFFECTIVE_DATE
     ,CALCULATION_EFFECTIVE_DATE
     ,USAGE_CODE
     ,GL_PERIOD_NAME
     ,PA_PERIOD_NAME
     ,EXPENDITURE_ITEM_DATE
     ,LAST_UPDATED_BY
     ,CREATED_BY
     ,LAST_UPDATE_LOGIN
    From GL_AUTO_ALLOC_SET_HISTORY
    Where REQUEST_ID = p_request_Id;

Line: 78

      Select
           STEP_NUMBER
         ,  BATCH_ID
         ,  BATCH_TYPE_CODE
         ,  ALLOCATION_METHOD_CODE
         ,  OWNER
   From   GL_AUTO_ALLOC_BATCH_HISTORY
   Where REQUEST_ID  = p_request_Id ;

Line: 108

    ,l_last_updated_by
    ,l_created_by
    ,l_last_update_login;

Line: 226

                       'Inserting into GL_AUTO_ALLOC_BAT_HIST_DET');

Line: 227

              Insert Into GL_AUTO_ALLOC_BAT_HIST_DET (
                     REQUEST_ID
                    ,PARENT_REQUEST_ID
                    ,STEP_NUMBER
                    ,PROGRAM_NAME_CODE
                    ,LAST_UPDATE_DATE
                    ,LAST_UPDATED_BY
                    ,LAST_UPDATE_LOGIN
                    ,CREATION_DATE
                    ,CREATED_BY
                    ,STATUS_CODE
                    ,RUN_MODE )
                Values
                   (  req_id
                     ,p_request_Id
                     ,l_step_number
                     ,l_program_name_code
                     ,sysdate
                     ,l_last_updated_by
                     ,l_last_update_login
                     ,sysdate
                     ,l_created_by
                     ,NULL
                     ,'P'
                     );