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 128: FROM jtf_rs_teams_vl team, wf_local_roles wlr

124:
125: CURSOR c_team_wf_del IS
126: SELECT team.team_id, team.team_name, team.email_address
127: ,team.start_date_active, team.end_date_active
128: FROM jtf_rs_teams_vl team, wf_local_roles wlr
129: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) < l_sysdate
130: AND wlr.orig_system_id = team.team_id
131: AND wlr.orig_system = l_team_orig_system
132: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id)

Line 145: FROM jtf_rs_teams_vl team, wf_local_roles wlr

141: CURSOR c_team_wf_upd IS
142: SELECT team.team_id, team.team_name, team.email_address
143: ,team.end_date_active, team.start_date_active
144: ,wlr.start_date wlr_start_date, wlr.expiration_date wlr_exp_date
145: FROM jtf_rs_teams_vl team, wf_local_roles wlr
146: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
147: AND wlr.orig_system_id = team.team_id
148: AND wlr.orig_system = l_team_orig_system
149: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id)

Line 182: FROM jtf_rs_teams_vl team

178:
179: CURSOR c_team_wf_crt IS
180: SELECT team.team_id, team.team_name, team.email_address
181: ,team.end_date_active, team.start_date_active
182: FROM jtf_rs_teams_vl team
183: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
184: AND NOT EXISTS (SELECT 1 FROM wf_local_roles wlr
185: WHERE wlr.orig_system_id = team.team_id
186: AND wlr.orig_system = l_team_orig_system