APPS.PA_GL_AUTOALLOC_PKG SQL Statements

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

Line: 14

   SELECT DISTINCT a.period_type
   FROM pa_alloc_rules_all a,
 	gl_auto_alloc_batches b
   WHERE b.allocation_set_id = p_allocation_set_id
   AND   b.batch_type_code = 'P'
   AND   a.rule_id = b.batch_id;

Line: 109

   select period_type, org_id -- Fix for bug : 4640479
   into v_period_type , l_org_id
   from pa_alloc_rules_all
   where rule_id = p_rule_id;

Line: 170

 Select Status_Code
 From GL_AUTO_ALLOC_BATCH_HISTORY
 Where REQUEST_ID = p_request_Id
 AND   STEP_NUMBER = p_step_number;

Line: 176

 Select
  Meaning
 ,Description
 From gl_lookups
 Where LOOKUP_TYPE = 'AUTOALLOCATION_STATUS'
 And LOOKUP_CODE = v_lookup_code;

Line: 183

  Select request_id
  From GL_AUTO_ALLOC_BAT_HIST_DET
  Where PARENT_REQUEST_ID = p_request_Id
  And STEP_NUMBER = p_step_number
  order by request_id desc;