APPS.JTF_RS_TEAM_MEMBERS_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1095: FROM jtf_rs_role_relations

1091: CURSOR c_related_role_count(
1092: l_team_member_id IN NUMBER)
1093: IS
1094: SELECT count(*)
1095: FROM jtf_rs_role_relations
1096: WHERE role_resource_type = 'RS_TEAM_MEMBER'
1097: AND role_resource_id = l_team_member_id
1098: AND ( end_date_active is null OR end_date_active >= sysdate )
1099: AND nvl(delete_flag,'N') <> 'Y';