APPS.WF_MAILER_PARAMETER dependencies on FND_SVC_COMPONENTS

Line 982: l_component_id fnd_svc_components.component_id%TYPE;

978: -- the value of the parameter.
979: FUNCTION GetValueForCorr(pCorrId IN VARCHAR2, pName IN VARCHAR2) RETURN VARCHAR2
980: IS
981:
982: l_component_id fnd_svc_components.component_id%TYPE;
983: l_value fnd_svc_comp_param_vals.parameter_value%TYPE;
984: l_component_found boolean;
985: l_corrid varchar2(40);
986:

Line 989: FROM FND_SVC_COMPONENTS

985: l_corrid varchar2(40);
986:
987: CURSOR c_get_components_for_corr is
988: SELECT component_id
989: FROM FND_SVC_COMPONENTS
990: WHERE
991: l_corrid like correlation_id and
992: component_type = 'WF_MAILER'
993: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;

Line 997: FROM FND_SVC_COMPONENTS

993: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;
994:
995: CURSOR c_get_components_for_null_corr is
996: SELECT component_id
997: FROM FND_SVC_COMPONENTS
998: WHERE
999: correlation_id is null and
1000: component_type = 'WF_MAILER'
1001: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;