APPS.ALR_ACTION_OUTPUTS_PKG dependencies on ALR_ALERTS
Line 99: from alr_alerts
95: from fnd_application
96: where application_short_name = X_APPLICATION_SHORT_NAME;
97:
98: select alert_id into l_alert_id 99: from alr_alerts 100: where application_id = l_app_id
101: and alert_name = X_ALERT_NAME;
102:
103: select action_id into l_action_id