APPS.ALR_ACTION_OUTPUTS_PKG dependencies on ALR_ACTIONS

Line 104: from alr_actions

100: where application_id = l_app_id
101: and alert_name = X_ALERT_NAME;
102:
103: select action_id into l_action_id
104: from alr_actions
105: where application_id = l_app_id
106: and alert_id = l_alert_id
107: and name = X_ACTION_NAME
108: and (((END_DATE_ACTIVE is null)