APPS.PJM_UTILS SQL Statements

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

Line: 11

select  PRIMARY_UOM_QUANTITY
into L_qty
from MTL_DEMAND
where  DEMAND_SOURCE_LINE = X_line_id
AND    DEMAND_SOURCE_TYPE IN (2,8,12)
AND    RESERVATION_TYPE IN (2,3);

Line: 51

  SELECT accum.accum_period
  FROM   pa_project_accum_headers accum
  ,      pa_periods per
  WHERE  accum.project_id = C_project_id
  AND    accum.task_id    = nvl(C_task_id, accum.task_id)
  AND    per.period_name  = accum.accum_period
  ORDER BY per.start_date desc;

Line: 62

  SELECT accum.accum_period
  FROM   pa_project_accum_headers accum
  ,      pa_implementations_all imp
  ,      gl_sets_of_books sob
  ,      gl_periods per
  ,      pa_projects_all pa
  WHERE  accum.project_id    = C_project_id
  AND pa.project_id = accum.project_id
  AND    accum.task_id       = nvl(C_task_id, accum.task_id)
  AND    sob.set_of_books_id = imp.set_of_books_id
  AND    per.period_set_name = sob.period_set_name
  AND    per.period_type     = sob.accounted_period_type
  AND    per.period_name     = accum.accum_period
  AND imp.org_id = pa.org_id
  ORDER BY per.start_date desc;

Line: 80

  select accumulation_period_type
  into   L_accum_period_type
  from   pa_implementations;

Line: 132

  select wac.class_code
  from   wip_accounting_classes wac
  ,    ( select 2 lvl
         ,      wip_acct_class_code
         ,      eam_acct_class_code
         from   pjm_project_parameters
         where  organization_id = X_inventory_org_id
         and    project_id = X_project_id
         union all
         select 1 lvl
         ,      wip_acct_class_code
         ,      eam_acct_class_code
         from   pjm_task_wip_acct_classes
         where  organization_id = X_inventory_org_id
         and    project_id = X_project_id
         and    task_id = X_task_id ) pjm
  where  wac.organization_id = X_inventory_org_id
  and    wac.class_code in ( pjm.wip_acct_class_code , pjm.eam_acct_class_code )
  and    wac.class_type = X_class_type
  order by lvl , wac.class_code;