eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_TAGPROCESS_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 16: -- JTF_RS_GROUPS_B, jtf_rs_role_relations, jtf_group_members,

12: -- for Acknowledgement account.
13: -- Liang Xia 12/6/2002 Fixed GSCC warning: NOCOPY, no G_MISS...
14: -- Liang Xia 01/15/2003 Fixed bug 2752169:changed jtf_rs_resource_members_vl to jtf_rs_resource_members
15: -- Liang Xia 09/18/2003 Fixed bug 3130813: added validation on User-responsibility, and end_date_active for
16: -- JTF_RS_GROUPS_B, jtf_rs_role_relations, jtf_group_members,
17: -- Liang Xia 09/24/2003 add extra validation on isValidAgent with GROUP usage ='CALL' (Call Center)
18: -- Liang Xia 08/13/2004 Modified getTagValue to reuse tag based on
19: -- profile IEM_REPROCESS_ALL_TAGS
20: -- Liang Xia 12/22/2004 Fixed bug 4079440. Init of IEM_REPROCESS_ALL_TAGS should act as 'N'

Line 1005: select count(*) into l_role_count from jtf_rs_role_relations a, jtf_rs_roles_vl b

1001: if l_asso_count < 1 then
1002: return false;
1003: end if;
1004:
1005: select count(*) into l_role_count from jtf_rs_role_relations a, jtf_rs_roles_vl b
1006: where a.role_resource_id=p_agent_id and a.role_id=b.role_id
1007: and b.role_type_code='ICENTER'
1008: and a.delete_flag='N'
1009: and a.START_DATE_ACTIVE< sysdate and ( a.END_DATE_ACTIVE>sysdate or a.END_DATE_ACTIVE is null);