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

Line 57: FROM jtf_rs_teams_b team, wf_local_user_roles wlur

53: -- These workflow local user role records have to be inactivated.
54:
55: CURSOR c_team_wf_ur_del IS
56: SELECT team.team_id, team.start_date_active, team.end_date_active
57: FROM jtf_rs_teams_b team, wf_local_user_roles wlur
58: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) < l_sysdate
59: AND wlur.role_orig_system_id = team.team_id
60: AND wlur.role_orig_system = l_team_orig_system
61: AND wlur.role_name = l_team_orig_system||':'||to_char(team.team_id)

Line 109: FROM jtf_rs_teams_b team, wf_local_user_roles wlur

105: -- These workflow user role records have to be updated with new values.
106:
107: CURSOR c_team_wf_ur_upd IS
108: SELECT team.team_id, team.start_date_active, team.end_date_active
109: FROM jtf_rs_teams_b team, wf_local_user_roles wlur
110: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
111: AND wlur.role_orig_system_id = team.team_id
112: AND wlur.role_orig_system = l_team_orig_system
113: AND wlur.role_name = l_team_orig_system||':'||to_char(team.team_id)

Line 1329: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team

1325: SELECT mem.team_resource_id resource_id, mem.team_id
1326: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1327: ,least (NVL (team.end_date_active, l_fnd_date) ,
1328: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1329: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1330: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1331: AND mem.team_resource_id = ext.resource_id
1332: AND mem.resource_type = 'INDIVIDUAL'
1333: AND mem.team_id = team.team_id

Line 1357: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team

1353: SELECT mem.team_resource_id resource_id, mem.team_id, ext.category, ext.resource_name
1354: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1355: ,least (NVL (team.end_date_active, l_fnd_date) ,
1356: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1357: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1358: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1359: AND mem.team_resource_id = ext.resource_id
1360: AND mem.resource_type = 'INDIVIDUAL'
1361: AND mem.team_id = team.team_id

Line 1383: FROM jtf_rs_groups_b grp, jtf_rs_team_members mem, jtf_rs_teams_b team

1379: SELECT mem.team_resource_id group_id, mem.team_id
1380: ,greatest (team.start_date_active, grp.start_date_active) m_start_date_active
1381: ,least (NVL (team.end_date_active, l_fnd_date) ,
1382: NVL (grp.end_date_active, l_fnd_date)) m_end_date_active
1383: FROM jtf_rs_groups_b grp, jtf_rs_team_members mem, jtf_rs_teams_b team
1384: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1385: AND mem.team_resource_id = grp.group_id
1386: AND mem.resource_type = 'GROUP'
1387: AND mem.team_id = team.team_id