APPS.ASP_ALERTS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 65

    select
      sub.subscription_id,
      sub.subscriber_name,
      sub.delivery_channel,
      sub.user_id
    from
      asp_alert_subscriptions sub
    where sub.alert_code = c_alert_code;

Line: 75

    select
      sub.subscription_id,
      sub.subscriber_name,
      sub.delivery_channel,
      sub.user_id
    from
      asp_alert_subscriptions sub,
      (select salesforce_id
       from as_accesses_all
       where customer_id = c_customer_id
         and lead_id is null
         and sales_lead_id is null
       group by salesforce_id) acc
    where sub.alert_code = c_alert_code
          and sub.resource_id = acc.salesforce_id;