APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 551: FROM jtf_rs_group_members mem, jtf_rs_groups_b grp

547: CURSOR grp_cur IS
548: SELECT mem.group_id, grp.group_number,
549: trunc(grp.start_date_active) start_date_active,
550: trunc(grp.end_date_active) end_date_active
551: FROM jtf_rs_group_members mem, jtf_rs_groups_b grp
552: WHERE mem.group_id = grp.group_id
553: AND nvl(mem.delete_flag,'N') <> 'Y'
554: AND l_sysdate between trunc(grp.start_date_active) and nvl(trunc(grp.end_date_active),l_sysdate)
555: AND mem.resource_id = ll_resource_id;

Line 1244: FROM jtf_rs_group_members mem, jtf_rs_groups_b grp, jtf_rs_resource_extns res

1240: CURSOR grp_mem_cur IS
1241: SELECT mem.resource_id,
1242: greatest(l_start_date_active, res.start_date_active) grp_mem_start_date,
1243: least (nvl(l_end_date_active, l_g_miss_date), nvl(res.end_date_active, l_g_miss_date)) grp_mem_end_date
1244: FROM jtf_rs_group_members mem, jtf_rs_groups_b grp, jtf_rs_resource_extns res
1245: WHERE mem.group_id = grp.group_id
1246: AND mem.resource_id = res.resource_id
1247: AND nvl(mem.delete_flag,'N') <> 'Y'
1248: AND l_sysdate between trunc(res.start_date_active) and nvl(trunc(res.end_date_active),l_sysdate)