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_CONC_WF_PUB dependencies on JTF_RS_TEAMS_VL

Line 72: FROM jtf_rs_teams_vl team, wf_local_roles wlr

68:
69: CURSOR c_team_wf_del IS
70: SELECT team.team_id, team.team_name, team.email_address
71: ,team.start_date_active, team.end_date_active
72: FROM jtf_rs_teams_vl team, wf_local_roles wlr
73: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) < l_sysdate
74: AND wlr.orig_system_id = team.team_id
75: AND wlr.orig_system = l_team_orig_system
76: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id)

Line 89: FROM jtf_rs_teams_vl team, wf_local_roles wlr

85: CURSOR c_team_wf_upd IS
86: SELECT team.team_id, team.team_name, team.email_address
87: ,team.end_date_active, team.start_date_active
88: ,wlr.start_date wlr_start_date, wlr.expiration_date wlr_exp_date
89: FROM jtf_rs_teams_vl team, wf_local_roles wlr
90: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
91: AND wlr.orig_system_id = team.team_id
92: AND wlr.orig_system = l_team_orig_system
93: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id)

Line 126: FROM jtf_rs_teams_vl team

122:
123: CURSOR c_team_wf_crt IS
124: SELECT team.team_id, team.team_name, team.email_address
125: ,team.end_date_active, team.start_date_active
126: FROM jtf_rs_teams_vl team
127: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
128: AND NOT EXISTS (SELECT 1 FROM wf_local_roles wlr
129: WHERE wlr.orig_system_id = team.team_id
130: AND wlr.orig_system = l_team_orig_system