APPS.PO_PALT_ASSIGNMENT_WF SQL Statements

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

Line: 36

  SELECT PO_PALT_WF_ITEMKEY_S.NEXTVAL INTO l_seq_for_item_key FROM sys.dual;

Line: 41

  SELECT assignment_number, buyer_id, estimated_completion_days, assignment_start_date ,milestone_template_id
  INTO l_assignment_number, l_buyer_id, l_est_comp_days, l_start_date, l_ms_temp_id
  FROM po_clm_assignments
  WHERE assignment_id = pAssignmentId;

Line: 89

  SELECT employee_id INTO l_employee_id
  FROM fnd_user
  WHERE user_id = fnd_global.user_id;

Line: 113

  SELECT GSB.currency_code INTO l_func_curr
  FROM  FINANCIALS_SYSTEM_PARAMS_all FSP,
        GL_SETS_OF_BOOKS GSB
  WHERE FSP.set_of_books_id = GSB.set_of_books_id
  AND   FSP.org_id=l_curr_org_id;