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_TEAMS_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 700: FROM jtf_rs_team_members jrgm,

696: l_team_id IN NUMBER )
697: IS
698: SELECT min(jrrr.start_date_active),
699: max(jrrr.end_date_active)
700: FROM jtf_rs_team_members jrgm,
701: jtf_rs_role_relations jrrr
702: WHERE jrgm.team_member_id = jrrr.role_resource_id
703: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
704: AND nvl(jrrr.delete_flag, 'N') <> 'Y'

Line 714: FROM jtf_rs_team_members jrgm,

710: CURSOR c_team_mbr_role_dates_sec(
711: l_team_id IN NUMBER )
712: IS
713: SELECT min(jrrr.start_date_active)
714: FROM jtf_rs_team_members jrgm,
715: jtf_rs_role_relations jrrr
716: WHERE jrgm.team_member_id = jrrr.role_resource_id
717: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
718: AND nvl(jrrr.delete_flag, 'N') <> 'Y'

Line 730: jtf_rs_team_members TM1,

726: IS
727: SELECT 'Y'
728: FROM jtf_rs_teams_vl T1,
729: jtf_rs_teams_vl T2,
730: jtf_rs_team_members TM1,
731: jtf_rs_team_members TM2,
732: jtf_rs_team_usages TU1,
733: jtf_rs_team_usages TU2,
734: jtf_rs_role_relations RR1,

Line 731: jtf_rs_team_members TM2,

727: SELECT 'Y'
728: FROM jtf_rs_teams_vl T1,
729: jtf_rs_teams_vl T2,
730: jtf_rs_team_members TM1,
731: jtf_rs_team_members TM2,
732: jtf_rs_team_usages TU1,
733: jtf_rs_team_usages TU2,
734: jtf_rs_role_relations RR1,
735: jtf_rs_role_relations RR2