APPS.ALR_RESPONSE_ACTIONS_PKG dependencies on ALR_ALERTS

Line 109: from alr_alerts

105: from fnd_application
106: where application_short_name = X_APPLICATION_SHORT_NAME;
107:
108: select alert_id into l_alert_id
109: from alr_alerts
110: where application_id = l_app_id
111: and alert_name = X_ALERT_NAME;
112:
113: select response_set_id into l_response_set_id