APPS.ALR_PERIODIC_SET_MEMBERS_PKG dependencies on ALR_ALERTS

Line 124: from alr_alerts

120: where application_short_name = X_CHILD_APPLICATION_SHORT_NAME;
121:
122: if X_CHILD_ALERT_NAME is not null then
123: select alert_id into l_child_alert_id
124: from alr_alerts
125: where application_id = l_child_app_id
126: and alert_name = X_CHILD_ALERT_NAME;
127: end if;
128: