APPS.QA_SOLUTION_CAR_PKG SQL Statements

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

Line: 122

     SELECT employee_num
     FROM   mtl_employees_current_view
     WHERE  full_name = p_requestor;

Line: 131

     SELECT fu.user_name
       FROM hr_employees_current_v hecv, fnd_user fu
      WHERE hecv.employee_id = fu.employee_id
        AND hecv.full_name = p_requestor;

Line: 179

  QA_SOLUTION_DISPOSITION_PKG.UPDATE_STATUS(l_plan_id, p_collection_id, p_occurrence);

Line: 295

    SELECT meaning
      FROM mfg_lookups
     WHERE lookup_type = type
       AND lookup_code = 1;

Line: 388

      SELECT lookup_code
        FROM mfg_lookups
       WHERE lookup_type = p_lookup_type
         AND upper(meaning) = upper(ltrim(rtrim(p_meaning)));

Line: 409

      SELECT plan_id
        FROM qa_plans
       WHERE name = p_plan_name;

Line: 429

      SELECT organization_id
        FROM mtl_parameters
       WHERE organization_code = p_organization_code;