APPS.ALR_ACTION_SET_MEMBERS_PKG dependencies on ALR_ALERTS

Line 124: from alr_alerts

120: from fnd_application
121: where application_short_name = X_APPLICATION_SHORT_NAME;
122:
123: select alert_id into l_alert_id
124: from alr_alerts
125: where application_id = l_app_id
126: and alert_name = X_ALERT_NAME;
127:
128: select action_set_id into l_action_set_id