APPS.IEM_TAGPROCESS_PUB dependencies on JTF_RS_GROUP_MEMBERS

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