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.

[Home] [Help]

APPS.JTF_RS_GROUPS_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 925: FROM jtf_rs_team_members jrtm,

921: l_group_id IN NUMBER )
922: IS
923: SELECT min(jrrr.start_date_active),
924: max(jrrr.end_date_active)
925: FROM jtf_rs_team_members jrtm,
926: jtf_rs_role_relations jrrr
927: WHERE jrtm.team_member_id = jrrr.role_resource_id
928: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
929: AND nvl(jrrr.delete_flag, 'N') <> 'Y'

Line 940: FROM jtf_rs_team_members jrtm,

936: CURSOR c_team_mbr_role_dates_sec(
937: l_group_id IN NUMBER )
938: IS
939: SELECT min(jrrr.start_date_active)
940: FROM jtf_rs_team_members jrtm,
941: jtf_rs_role_relations jrrr
942: WHERE jrtm.team_member_id = jrrr.role_resource_id
943: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
944: AND nvl(jrrr.delete_flag, 'N') <> 'Y'