APPS.ALR_RESPONSE_VARIABLES_PKG dependencies on ALR_ALERTS

Line 111: from alr_alerts

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