APPS.IEM_TAGPROCESS_PUB dependencies on JTF_RS_ROLES_VL

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);