DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on FND_SVC_COMP_PARAM_VALS

Line 1744: FROM fnd_svc_comp_param_vals a,

1740:
1741: if (p_ntf_pref = 'SUMHTML') then
1742:
1743: SELECT a.parameter_value into l_summary_param
1744: FROM fnd_svc_comp_param_vals a,
1745: fnd_svc_components b,
1746: fnd_svc_comp_params_vl c
1747: WHERE b.component_id = a.component_id
1748: AND b.component_type = c.component_type

Line 1757: FROM fnd_svc_comp_param_vals a,

1753:
1754: else
1755:
1756: SELECT a.parameter_value into l_summary_param
1757: FROM fnd_svc_comp_param_vals a,
1758: fnd_svc_components b,
1759: fnd_svc_comp_params_vl c
1760: WHERE b.component_id = a.component_id
1761: AND b.component_type = c.component_type

Line 2179: from fnd_svc_comp_param_vals_v v,

2175: select p.parameter_name,
2176: v.parameter_value,
2177: v.parameter_description,
2178: v.default_parameter_value
2179: from fnd_svc_comp_param_vals_v v,
2180: fnd_svc_comp_params_b p
2181: where p.encrypted_flag = 'N'
2182: and v.component_id = p_comp_id
2183: and v.parameter_id = p.parameter_id