APPS.ALR_ALERT_OUTPUTS_PKG dependencies on ALR_ALERTS

Line 117: from ALR_ALERTS

113: from FND_APPLICATION
114: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;
115:
116: select ALERT_ID into l_alert_id
117: from ALR_ALERTS
118: where APPLICATION_ID = l_app_id
119: and ALERT_NAME = X_ALERT_NAME;
120:
121: select last_updated_by, last_update_date