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