APPS.GL_AUTO_ALLOC_VW_PKG SQL Statements

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

Line: 7

  Select Name
  From gl_alloc_batches
  Where Allocation_Batch_Id = BATCH_ID
  And Actual_flag = BATCH_TYPE_CODE ;

Line: 13

  Select Name
  From Gl_Recurring_Batches
  Where Recurring_Batch_Id =  BATCH_ID
  And Budget_Flag = 'N';

Line: 19

  Select rule_name
  From pa_alloc_rules_all
  Where rule_id = BATCH_ID;

Line: 54

       Select Display_Name
       From GL_WF_ROLES_V
       Where Name = OWNER;