APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 2316: FROM jtf_rs_team_members jrtm,

2312: l_resource_id IN NUMBER )
2313: IS
2314: SELECT min(jrrr.start_date_active),
2315: max(jrrr.end_date_active)
2316: FROM jtf_rs_team_members jrtm,
2317: jtf_rs_role_relations jrrr
2318: WHERE jrtm.team_member_id = jrrr.role_resource_id
2319: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
2320: AND nvl(jrrr.delete_flag, 'N') <> 'Y'

Line 2331: FROM jtf_rs_team_members jrtm,

2327: CURSOR c_team_mbr_role_dates_sec(
2328: l_resource_id IN NUMBER )
2329: IS
2330: SELECT min(jrrr.start_date_active)
2331: FROM jtf_rs_team_members jrtm,
2332: jtf_rs_role_relations jrrr
2333: WHERE jrtm.team_member_id = jrrr.role_resource_id
2334: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
2335: AND nvl(jrrr.delete_flag, 'N') <> 'Y'

Line 4251: FROM jtf_rs_team_members jrtm,

4247: l_resource_id IN NUMBER )
4248: IS
4249: SELECT min(jrrr.start_date_active),
4250: max(jrrr.end_date_active)
4251: FROM jtf_rs_team_members jrtm,
4252: jtf_rs_role_relations jrrr
4253: WHERE jrtm.team_member_id = jrrr.role_resource_id
4254: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4255: AND nvl(jrrr.delete_flag, 'N') <> 'Y'

Line 4266: FROM jtf_rs_team_members jrtm,

4262: CURSOR c_team_mbr_role_dates_sec(
4263: l_resource_id IN NUMBER )
4264: IS
4265: SELECT min(jrrr.start_date_active)
4266: FROM jtf_rs_team_members jrtm,
4267: jtf_rs_role_relations jrrr
4268: WHERE jrtm.team_member_id = jrrr.role_resource_id
4269: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4270: AND nvl(jrrr.delete_flag, 'N') <> 'Y'