APPS.IEM_ROUTE_PUB dependencies on JTF_RS_ROLES_B

Line 13: -- Liang Xia 08/06/2002 Changed jtf_rs_roles_vl to jtf_rs_roles_b, jtf_rs_group_members_vl to jtf_rs_group_members for

9: -- Liang Xia 01/10/2002 fix bug that if the number of rules for a classification is less than
10: -- that of classification with higher priority, this classification
11: -- is never satisfied. ( No bug logged, shipped with FP-M )
12: -- Liang Xia 06/05/2002 Added Dynamic Route function
13: -- Liang Xia 08/06/2002 Changed jtf_rs_roles_vl to jtf_rs_roles_b, jtf_rs_group_members_vl to jtf_rs_group_members for
14: -- performance issue.
15: -- Liang Xia 11/12/2002 Added All_email tag, which overwrite the rules
16: -- Fixed GSCC warning: NOCOPY, FND_API.G_MISS...
17: -- Liang Xia 11/26/2002 Not to route groups that are expired.

Line 209: roleTypeCode JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE := 'ICENTER';

205:
206: groupOK Boolean := TRUE;
207:
208: resourceId JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE;
209: roleTypeCode JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE := 'ICENTER';
210: deleteFlag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE := 'N';
211: groupUsage JTF_RS_GROUP_USAGES.usage%TYPE :='CALL';
212:
213: errorMessage varchar2(2000);

Line 221: jtf_rs_roles_b a,

217: c.resource_id
218: into
219: resourceId
220: from
221: jtf_rs_roles_b a,
222: jtf_rs_role_relations b,
223: jtf_rs_group_members c,
224: --jtf_rs_resource_values d,
225: iem_agents d,