DBA Data[Home] [Help]

APPS.ASP_ALERTS_PUB dependencies on ASP_ALERT_SUBSCRIPTIONS

Line 71: asp_alert_subscriptions sub

67: sub.subscriber_name,
68: sub.delivery_channel,
69: sub.user_id
70: from
71: asp_alert_subscriptions sub
72: where sub.alert_code = c_alert_code;
73:
74: cursor get_subs_secured(c_alert_code in VARCHAR2, c_customer_id in NUMBER) is
75: select

Line 81: asp_alert_subscriptions sub,

77: sub.subscriber_name,
78: sub.delivery_channel,
79: sub.user_id
80: from
81: asp_alert_subscriptions sub,
82: (select salesforce_id
83: from as_accesses_all
84: where customer_id = c_customer_id
85: and lead_id is null