APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on JTF_RS_TEAM_MEMBERS

Line 568: FROM jtf_rs_team_members mem, jtf_rs_teams_b tm

564: CURSOR team_cur IS
565: SELECT mem.team_id,
566: trunc(tm.start_date_active) start_date_active,
567: trunc(tm.end_date_active) end_date_active
568: FROM jtf_rs_team_members mem, jtf_rs_teams_b tm
569: WHERE mem.team_id = tm.team_id
570: AND nvl(mem.delete_flag,'N') <> 'Y'
571: AND l_sysdate between trunc(tm.start_date_active) and nvl(trunc(tm.end_date_active),l_sysdate)
572: AND mem.team_resource_id = ll_resource_id

Line 1255: FROM jtf_rs_team_members mem, jtf_rs_teams_b tm

1251: CURSOR grp_as_team_mem_cur IS
1252: SELECT mem.team_id,
1253: trunc(tm.start_date_active) start_date_active,
1254: trunc(tm.end_date_active) end_date_active
1255: FROM jtf_rs_team_members mem, jtf_rs_teams_b tm
1256: WHERE mem.team_id = tm.team_id
1257: AND nvl(mem.delete_flag,'N') <> 'Y'
1258: -- AND l_sysdate between trunc(tm.start_date_active) and nvl(trunc(tm.end_date_active),l_sysdate)
1259: AND mem.team_resource_id = p_group_id

Line 1774: FROM jtf_rs_team_members mem, jtf_rs_teams_b team

1770:
1771: CURSOR team_mem_cur IS
1772: SELECT mem.team_resource_id,
1773: mem.resource_type
1774: FROM jtf_rs_team_members mem, jtf_rs_teams_b team
1775: WHERE mem.team_id = team.team_id
1776: AND nvl(mem.delete_flag,'N') <> 'Y'
1777: -- AND l_sysdate between trunc(team.start_date_active) and nvl(trunc(team.end_date_active),l_sysdate)
1778: AND team.team_id = p_team_id;