APPS.IEM_ROUTE_PUB dependencies on IEM_ACCOUNT_ROUTES
Line 330: cursor c_routes (p_enabled_flag iem_account_routes.enabled_flag%type,
326: l_api_name CONSTANT VARCHAR2(30):= 'Route';
327:
328:
329: --The active routes in the system 330: cursor c_routes (p_enabled_flag iem_account_routes.enabled_flag%type, 331: p_account_id iem_mstemail_accounts.email_account_id%type)
332: is
333: select
334: a.route_id,
Line 342: iem_account_routes b
338: b.destination_group_id,
339: b.default_group_id
340: from
341: iem_routes a, 342: iem_account_routes b 343: where
344: a.route_id = b.route_id
345: and
346: b.enabled_flag = p_enabled_flag