Find Logging level for EBS R12.2 Workflow services

col component_name format A50

col parameter_name format a45 head "Parameter Name"

col parameter_value format a30 head "Value"

SELECT b.component_name,

  c.parameter_name,

  a.parameter_value

FROM fnd_svc_comp_param_vals a,

  fnd_svc_components b,

  fnd_svc_comp_params_vl c

WHERE b.component_id = a.component_id

AND b.component_type = c.component_type

AND c.parameter_id = a.parameter_id

AND c.parameter_name like '%LOG_LEVEL%';