DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on FND_SVC_COMPONENTS

Line 531: from fnd_svc_components a, FND_SVC_COMP_PARAM_VALS_V b

527:
528: CURSOR c_mailer_email IS
529: select a.component_name,parameter_value,component_status,
530: decode(component_status, 'RUNNING',0,'STARTING',1,'DEACTIVATED_SYSTEM',2,'STOPPED_ERROR',2) status
531: from fnd_svc_components a, FND_SVC_COMP_PARAM_VALS_V b
532: where component_type='WF_MAILER'
533: and a.component_id=b.component_id
534: and b.parameter_name='REPLYTO'
535: and b.parameter_value IS NOT NULL