APPS.ALR_VALID_RESPONSES_PKG dependencies on ALR_ALERTS

Line 98: from alr_alerts

94: from fnd_application
95: where application_short_name = X_APPLICATION_SHORT_NAME;
96:
97: select alert_id into l_alert_id
98: from alr_alerts
99: where application_id = l_app_id
100: and alert_name = X_ALERT_NAME;
101:
102: select response_set_id into l_response_set_id