APPS.ALR_RESPONSE_ACTIONS_PKG dependencies on ALR_ACTIONS

Line 133: from alr_actions

129: and (response_name = X_RESPONSE_NAME)));
130:
131: /* end_date_active can be a null column */
132: select action_id into l_action_id
133: from alr_actions
134: where application_id = l_app_id
135: and alert_id = l_alert_id
136: and name = X_ACTION_NAME
137: and ((end_date_active is null)