DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on FND_SVC_COMP_PARAM_VALS

Line 1557: FROM fnd_svc_comp_param_vals a,

1553:
1554: if (p_ntf_pref = 'SUMHTML') then
1555:
1556: SELECT a.parameter_value into l_summary_param
1557: FROM fnd_svc_comp_param_vals a,
1558: fnd_svc_components b,
1559: fnd_svc_comp_params_vl c
1560: WHERE b.component_id = a.component_id
1561: AND b.component_type = c.component_type

Line 1570: FROM fnd_svc_comp_param_vals a,

1566:
1567: else
1568:
1569: SELECT a.parameter_value into l_summary_param
1570: FROM fnd_svc_comp_param_vals a,
1571: fnd_svc_components b,
1572: fnd_svc_comp_params_vl c
1573: WHERE b.component_id = a.component_id
1574: AND b.component_type = c.component_type

Line 1992: from fnd_svc_comp_param_vals_v v,

1988: select p.parameter_name,
1989: v.parameter_value,
1990: v.parameter_description,
1991: v.default_parameter_value
1992: from fnd_svc_comp_param_vals_v v,
1993: fnd_svc_comp_params_b p
1994: where p.encrypted_flag = 'N'
1995: and v.component_id = p_comp_id
1996: and v.parameter_id = p.parameter_id