APPS.ALR_ACTION_SETS_PKG dependencies on ALR_ALERTS

Line 112: from alr_alerts

108: from fnd_application
109: where application_short_name = X_APPLICATION_SHORT_NAME;
110:
111: select alert_id into l_alert_id
112: from alr_alerts
113: where application_id = l_app_id
114: and alert_name = X_ALERT_NAME;
115:
116: select action_set_id into l_action_set_id