APPS.IEM_EMAILPROC_PVT dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 59: from iem_route_classifications rt, fnd_user fu

55:
56: cursor c_classifications is
57: select rt.route_classification_id, rt.name, rt.description, fu.user_name,
58: to_char(rt.creation_date) creation_date, rt.boolean_type_code
59: from iem_route_classifications rt, fnd_user fu
60: where fu.user_id = rt.created_by and rt.route_classification_id<>0 and rt.deleted_flag='N'
61: order by UPPER(name) asc;
62:
63: cursor c_routes is

Line 280: from iem_route_classifications r, iem_account_route_class a

276:
277: cursor c_classifications(v_acct_Id number) is
278: select a.account_route_class_id, a.priority, r.route_classification_id,
279: r.name,r.description, r.boolean_type_code, a.enabled_flag
280: from iem_route_classifications r, iem_account_route_class a
281: where r.route_classification_id=a.route_classification_id
282: and a.email_account_id = v_acct_Id and r.route_classification_id<>0 and r.deleted_flag='N'
283: order by a.priority asc;
284: