APPS.PJM_MASS_TRANSFER_WF SQL Statements

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

Line: 38

  SELECT R.name
  FROM   pa_project_players P , wf_roles R
  WHERE  P.project_role_type = 'PROJECT MANAGER'
  AND    P.project_id = X_Project_ID
  AND    sysdate BETWEEN P.start_date_active AND nvl(P.end_date_active , sysdate + 1)
  AND    R.orig_system_id = P.person_id
  AND    R.orig_system = 'PER'
  ORDER BY decode(R.name , X_Requestor , 0 , 1) , R.name;

Line: 64

  SELECT 'Y'
  FROM   pjm_seiban_numbers
  WHERE  project_id = X_Project_ID;

Line: 113

  SELECT p.organization_id
  ,      mp.organization_code
  ,      org.name organization_name
  ,      p.from_project_id
  ,      p.to_project_id
  ,      p.transfer_date
  ,      p.transfer_mode
  ,      p.inventory_item_id
  ,      p.category_set_id
  ,      p.category_id
  ,      r.reason_name transfer_reason
  ,      p.transfer_reference
  FROM   pjm_mass_transfers p
  ,      mtl_parameters mp
  ,      hr_all_organization_units_tl org
  ,      mtl_transaction_reasons r
  WHERE  p.mass_transfer_id = X_Transfer_ID
  AND    mp.organization_id = p.organization_id
  AND    org.organization_id = mp.organization_id
  AND    org.language = userenv('LANG')
  AND    r.reason_id (+) = p.transfer_reason_id
  ;

Line: 139

  SELECT segment1 project_num , name project_name , description project_desc
  FROM   pa_projects_all
  WHERE  project_id = X_Project_ID
  UNION ALL
  SELECT project_number , project_name , project_name
  FROM   pjm_seiban_numbers
  WHERE  project_id = X_Project_ID;

Line: 153

  SELECT concatenated_segments , description
  FROM   mtl_system_items_b_kfv
  WHERE  organization_id = X_Organization_ID
  AND    inventory_item_id = X_Item_ID
  AND    X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_ONE_ITEM
  UNION ALL
  SELECT concatenated_segments , description
  FROM   mtl_categories_b_kfv
  WHERE  category_id = X_Category_ID
  AND    X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_CATEGORY;

Line: 656

SELECT from_task_id
,      to_task_id
FROM   pjm_mass_transfer_tasks
WHERE  mass_transfer_id = X_Transfer_ID;

Line: 664

SELECT task_number
,      task_name
FROM   pa_tasks
WHERE  task_id = X_Task_ID;