APPS.ALR_RESPONSE_SETS_PKG dependencies on ALR_ALERTS

Line 97: from alr_alerts

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