APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on JTF_RS_GROUPS_B

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)

Line 1472: FROM JTF_RS_GROUPS_B

1468:
1469: CURSOR c_grp_active (p_group_id IN NUMBER) IS
1470: SELECT trunc(START_DATE_ACTIVE) START_DATE_ACTIVE,
1471: trunc(END_DATE_ACTIVE) END_DATE_ACTIVE
1472: FROM JTF_RS_GROUPS_B
1473: WHERE GROUP_ID = P_GROUP_ID AND
1474: trunc(START_DATE_ACTIVE) <= l_sysdate AND
1475: NVL(trunc(END_DATE_ACTIVE), l_sysdate) >= l_sysdate;
1476:

Line 1789: FROM jtf_rs_groups_b

1785:
1786: CURSOR group_dates(c_group_id NUMBER) IS
1787: SELECT trunc(start_date_active) start_date_active,
1788: trunc(end_date_active) end_date_active
1789: FROM jtf_rs_groups_b
1790: WHERE group_id = c_group_id;
1791:
1792: l_team_mem_user_name wf_local_roles.name%TYPE;
1793: l_team_mem_orig_system wf_local_roles.orig_system%TYPE;

Line 2011: FROM JTF_RS_GROUPS_B

2007:
2008: CURSOR c_grp_active (p_group_id IN NUMBER) IS
2009: SELECT trunc(START_DATE_ACTIVE) START_DATE_ACTIVE,
2010: trunc(END_DATE_ACTIVE) END_DATE_ACTIVE
2011: FROM JTF_RS_GROUPS_B
2012: WHERE GROUP_ID = P_GROUP_ID AND
2013: trunc(START_DATE_ACTIVE) <= l_sysdate AND
2014: NVL(trunc(END_DATE_ACTIVE), l_sysdate) >= l_sysdate;
2015: