APPS.ALR_ACTION_SET_INPUTS_PKG dependencies on ALR_ALERTS
Line 91: from alr_alerts
87: from fnd_application
88: where application_short_name = X_APPLICATION_SHORT_NAME;
89:
90: select alert_id into l_alert_id 91: from alr_alerts 92: where application_id = l_app_id
93: and alert_name = X_ALERT_NAME;
94:
95: select action_set_id into l_action_set_id