eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 2317: FROM jtf_rs_team_members jrtm,

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

Line 2332: FROM jtf_rs_team_members jrtm,

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

Line 4242: FROM jtf_rs_team_members jrtm,

4238: l_resource_id IN NUMBER )
4239: IS
4240: SELECT min(jrrr.start_date_active),
4241: max(jrrr.end_date_active)
4242: FROM jtf_rs_team_members jrtm,
4243: jtf_rs_role_relations jrrr
4244: WHERE jrtm.team_member_id = jrrr.role_resource_id
4245: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4246: AND nvl(jrrr.delete_flag, 'N') <> 'Y'

Line 4257: FROM jtf_rs_team_members jrtm,

4253: CURSOR c_team_mbr_role_dates_sec(
4254: l_resource_id IN NUMBER )
4255: IS
4256: SELECT min(jrrr.start_date_active)
4257: FROM jtf_rs_team_members jrtm,
4258: jtf_rs_role_relations jrrr
4259: WHERE jrtm.team_member_id = jrrr.role_resource_id
4260: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4261: AND nvl(jrrr.delete_flag, 'N') <> 'Y'