APPS.IEM_EMAILPROC_PVT dependencies on FND_USER

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 65: from iem_routes rt, fnd_user fu where fu.user_id = rt.created_by

61: order by UPPER(name) asc;
62:
63: cursor c_routes is
64: select rt.route_id, rt.name, rt.description, rt.boolean_type_code, fu.user_name, to_char(rt.creation_date) creation_date
65: from iem_routes rt, fnd_user fu where fu.user_id = rt.created_by
66: order by UPPER(rt.name) asc;
67:
68: cursor c_emailProcs(v_rule_type varchar2) is
69: select ep.emailproc_id, ep.name, ep.description, ep.rule_type, fu.user_name, to_char(ep.creation_date) creation_date

Line 70: from iem_emailprocs ep, fnd_user fu

66: order by UPPER(rt.name) asc;
67:
68: cursor c_emailProcs(v_rule_type varchar2) is
69: select ep.emailproc_id, ep.name, ep.description, ep.rule_type, fu.user_name, to_char(ep.creation_date) creation_date
70: from iem_emailprocs ep, fnd_user fu
71: where ep.created_by=fu.user_id and ep.rule_type= v_rule_type
72: order by UPPER(name);
73: BEGIN
74: