DBA Data[Home] [Help]

APPS.IEM_TAGPROCESS_PUB dependencies on JTF_RS_GROUPS_B

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 1014: select count(*) into l_grp_count from jtf_rs_group_members a, JTF_RS_GROUPS_B b, JTF_RS_GROUP_USAGES c

1010: if l_role_count < 1 then
1011: return false;
1012: end if;
1013:
1014: select count(*) into l_grp_count from jtf_rs_group_members a, JTF_RS_GROUPS_B b, JTF_RS_GROUP_USAGES c
1015: where a.group_id = b.group_id
1016: and a.resource_id = p_agent_id
1017: and a.delete_flag = 'N'
1018: and b.START_DATE_ACTIVE< sysdate