APPS.JTF_RS_GROUP_MEMBERS_PVT dependencies on JTF_RS_GROUPS_B

Line 122: FROM JTF_RS_GROUPS_B a, JTF_RS_RESOURCE_EXTNS b

118: AND category = 'EMPLOYEE';
119:
120: CURSOR c_is_active(l_group_id IN NUMBER, l_resource_id IN NUMBER) IS
121: SELECT 'x'
122: FROM JTF_RS_GROUPS_B a, JTF_RS_RESOURCE_EXTNS b
123: WHERE a.group_id = l_group_id
124: AND b.resource_id = l_resource_id
125: AND trunc(sysdate) between a.start_date_active and nvl(a.end_date_active, sysdate)
126: AND trunc(sysdate) between b.start_date_active and nvl(b.end_date_active, sysdate);